Sitemap

Amicuk Programming Answers

Summation problem in fox formula

-0001-11-30   Views:2

Advertisement

Hi friends, My requirement is....I have GL Account, PO Number, Vender, costcenter  Scroll number and amount is displaying in layout. I have one more field let say TotalAmount. in this field i have populate sum of GL and PO Combination... I have write

Hi friends,
My requirement is....I have GL Account, PO Number, Vender, costcenter  Scroll number and amount is displaying in layout.
I have one more field let say TotalAmount. in this field i have populate sum of GL and PO Combination...
I have writen code in fox. Keeping GL Account, PO Number and amount in chaged fields..
DATA SUM TYPE F.
DATA SUM1 TYPE F.
DATA SUM2 TYPE F.
DATA PO TYPE EBELN.
DATA GL TYPE 0GL_ACCOUNT.
SUM = 0.
*BREAK-POINT.
FOREACH GL,PO .
SUM1 =  {0AMOUNT,GL,PO}.
SUM = SUM + SUM1.
ENDFOR.
{0PRICE,GL,PO} = SUM.
As it is not giving me Accurate result....
Itried in debug mode...and in trace ....fox is picking total cube values like GL Account, PO Number, Vender, costcenter  Scroll number  and summing up...But i want GL Account, PO Number wise.....
One more thing if i remove GL Account, PO Number  from changed field...fox proposing for changed field...
Thanks
Raju

The replay answer
Advertisement
Thanks for response...
UR right....Please suggest me...the variables i have created on PO and GL should have which properties like
Text Replacement - Characteristic Value.
Replacement Type - User Defined right.
Question 1 . should i restrict these variables in level or not. if  not so i have to remove PO and GL in changed fields and call variables in Fox right.
Question 2. IF so what about my layout...
or else please give a example if i create  variables for both..what exactly i have to do after that to effect the result values..

Go to See the other 10 answers

Summation problem in fox formula

Category:DefaultRelease time:-0001-11-30Views:130

Hi friends, My requirement is....I have GL Account, PO Number, Vender, costcenter  Scroll number and amount is displaying in layout. I have one more field let say TotalAmount. in this field i have populate sum of GL and PO Combination... I have write[More]

IP - Problem in FOX formula: how to use 0FISCPER3 counter of a DO function?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, IP 7.0: I'd like to define a top-down function which distributes the values in 0FISCPER3 = # to the periods selected by the user with two variables (period from and period to variable). -> Problem I experience is the conflict in different data ty[More]

Problem in Fox Formula..

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Total field i require GL and PO Combination wise SUM(amount). Variables      Provisions - Circle     MU Fiscal year/period     003.2010 Company code     RIL Controlling Area     RIL Header      Provisions - Circle     MU Fiscal year/period     00[More]

Problem with Nested loop in Fox-Formula

Category:DefaultRelease time:2015-10-11Views:130

Dear Experts, Let s share the scenario : MaterialGroups with following Keys for Example AAAA, BBBB, CCCC..., Materialgroups are selected in the 1st input ready query, which is assigned to DataProvider DP_1 in a  webtemplate. every Materialgroup has s[More]

Problem in writing Fox Formula

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, I need to write a formula to fill values in the  key figure. The value is to be sum of other two input ready key figures. ex a = b +c ( B and c are input ready key figures) To implement this i have to write a fox formula in planing functio[More]

Fox Formula In IP.

Category:DefaultRelease time:-0001-11-30Views:130

Hi Friends, I have a problem in Executing Fox Formula. I want to Add all rows of the Column.  And want to Use the Total Summation Of Column in Another Column Using ForEach Loop but it is not working as Expected. I Posted the Following Code : DATA Z_M[More]

How to implement this planning function using Fox formula

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am new to Fox. I want to implement this complex logic in a planning function i have A (Kf X from infoprovider Z_A), B (Kf Y from infoprovider Z_B) & moreover there is one more condition, If current FISCPER > variable value of FISCPER KF Z[More]

How using ABAP function in fox formula ?

Category:DefaultRelease time:2015-12-10Views:130

Hello, I want to launch standard function :"RSW_CURRENCY_TRANSLATION" by Fox formula. I declare this function in SAP Table :rsplf_fdir, and I can call this function by fox, with all parameters. But when I want to use it, I've a problem with the[More]

Fox Formula vs ABAP

Category:DefaultRelease time:-0001-11-30Views:130

Hi guys, I'm working with a Material Hierarchy (Main Group (MG)(0PRODH1), Group(G) (0PRODH2), Subgroup (0PRODH3) (SG) and Mat (0MATERIAL). In my Planning package I have a specific Hierarchy Node for 0MATERIAL. I need to perform a calculation in diffe[More]

Calculating a Leap Year with a FOX Formula

Category:DefaultRelease time:-0001-11-30Views:130

Hi to everybody. Is it posible to calculate a leap year using BPS in BW 3.5 with a FOX formula? The code i need to write is something like this: if ((year % 4 == 0) AND ((year % 100 != 0) OR (year % 400 == 0)) then   it is a leap year; else   it isn´[More]

Fox Formula in Integrated planning.

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a requirement like this. My data in cube is like this. SEASN BR    DU   ST      PS      VOL.. SS09    AD    BB   ST1    PS1     100 SS09    AD    BB   ST1    PS2     200. SS09    AD    BB   ST2    PS3     300. SS09    AD    BB   ST3   [More]

Hot
In my project, we asked vendor company to create the UI and css of the whole web application. We are using Trinidad in the project, trinidad use skin to customize the look and feel of the page. Since we have already had a set of css classes, we don't [More]
My daughter's ipod touch and my iphone are are the same account.  How do I set up adifferent account for her without losing everything she has purchased and downloaded?To keep from losing purchases you will both need to continue sharing the Apple ID [More]
I am trying to install SQL Server 2012 with SQL Server Data Tools on my laptop with Windows 8.1 standard edition.  It fails each time when it gets to the SSDT installation with the same 1935 error, other features still install.  The error text is as [More]
Hi, Our company have been purchasing iMacs for the past 4-5 years and installing Windows XP without any problems.  Last year we started installing Windows 7 64 bit onto, the then current, leopard model without any issues. We have recently purchased a [More]
when i login on behance it show error "Email is already linked to Adobe ID" i try login on cc desktop it show "there was a problem with your request please refresh the page and try again" help me [email protected]Hello - I believe we h [More]
Hi All,      I am not finding Oracle SOA Suite 11.1.1.6 downloads from oracle.com/ edelivery.oracle.com. Where can I find the downloads. SOA Suite 11.1.1.7 is available but I need the previous version 11.1.1.6. Regards, Nataraj R.Hi Vlad, I did. Howe [More]
I am going crazy with my Apple account. When I try to purchase apps, music, anything from the store I and asked to enter my Apple ID and password as usual. However, I get the message saying that either the Apple ID or password is incorrect. I know it [More]
Dear all, I would like to create a assessment in COPA, some expense will be allocated to the certain products, this means I can not specify 'From    To'. so I have to create a Group which include  these products for it. I do not know how to define th [More]
Does anyone know if one can use a non-dedicated interface (i.e. one through which other traffic flows) for redundancy? I ask this as the pair of 11503's in question will only have the two gig interfaces available, both of their slots filled with SSL [More]
Simply put: can my iBook wirelessly connect to my linksys router (and, thus, my ISP) and/or my airport express (and, thus, my printer)? I want to receive the ISP signal and have the option to print to my printer via Airport Express. Any help is appre [More]