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
i passed my internal table contains of all char type fileds to excel file in using function GUI_DOWNLOAD or  SAP_CONVERT_TO_XLS_FORMAT. but data show as below;      internal table          excel sheet. #1     1078137317      ->    1.08E+09 #2     201 [More]
I am using Dreamweaver CS5 and an this "P" shows up in the browser, the Live View, Live Code, but does not show up in the code for me to erase it. Any ideas? Below is part of the code file and a screen sot of the chararcter I want to remove. Any [More]
Hello Everybody. Whenever I do a preview of my website, for example, if I do a preview of an "about us" page, it works fine, but when I click on "about us" from its own like on the "home" page it shows up all...gone. I Will p [More]
Hi, We have uploaded the asset values using AS91 and passed the FI entry to reconcile with the asset master as on 31.03.06(last day of the previous year) Now when i am trying to scrap or retire the asset, the following messsage comes <b>Retirement o [More]
Hi, I recently upgraded to Mavericks Server - Overall the performance seems excellent but I miss some of the configuration options available in earlier versions. The firewall is extremely confusing to me as I have come across many articles on how to [More]
According to the implementation of controllers SOX in the company, I need to verify if the SAP ERP system must like standard functionality not allow to record documents that are not balanced (debit = credit). I appreciate its collaboration and I am a [More]
I have my Ipad 3 with AT&T, and I moved to Ecuador for vacation. I tried to insert a brand new micro sim from a local cellular provider, on the upper left corner it appears the anthena full connected and the 3G logo, also the brand of the local cellu [More]
Hi, all. What is the v$resource in 10g?? The folloing link is not sufficient to understand. http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2049.htm#sthref3892 Is there anyone who could provide me with a little more details?? [More]
Hello, i have a SAP Query to recalculate some conversion factors in the routing of a production order. Because the header unit of the routing is M2 and the routing operation is PC for example. No i need a idea how it is possible to update the fields [More]
I am getting this only with Safari - Safari can't connect to the server. Safari can't open the page "http://www.apple.com/" because it could not connect to the server "www.apple.com". This happens on every page I try and open, but only [More]