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
Hi all, I just received my new X1 Carbon 2015. This is the first time I purchase a Lenovo Device after years with Dell. Unfortunately, the sound quality is horrible, but I am not sure if this is by design of if the laptop is faulty.. The sound is ver [More]
Hi, I have exported Java 6.40 and finished the refresh successfully. And I imported the Java successfully. After importing Java, I restarted SAP but is not coming up. When I checked the dev_w0 trace file, I got the following information. trc file: "d [More]
I purchased my iMac from the local apple store on august 31st, that night after about 2 hours of use I noticed the screen had become quite pixelated I rebooted and everything was fine. Since that day I have had many of the same occurences. I have an [More]
Hello, I hope someone can point me in the right direction for my next assignment. I am very new at Java programming. For my next assignment for class I will need expand my previous program which was a mortgage calculator. The first assignment we wrot [More]
Hi all This problem can look funny to lot of you. I have project where i use Java on server side to perform some operation with MySQL. I have created connection to MySQL but there will be lot of users and connecting to database like i have done is no [More]
Hello friends, How to display the long text in the reports? I changed the bex settings in the info object definition as long text . But in the report iam getting the key and text as the same i am not getting the text . Can you help me??? Thanks Srini [More]
I'm afraid I cannot follow all this technical stuff, but I am VERY dissatisfied with my BT Broadband speed. The customer shouldn't have to know and do all that stuff. I was previously with Virgin and it just WORKED !   This is awful. When I run BT Sp [More]
Hi All I have here a DepoScreen (WebDynpro)application that runs with no user interaction, it shows data from BW,R/3 and KM. Since there is no User interaction i get once a day WebDynpro Session expired and i need to refresh it. I tried the following [More]
I have a problem with email attached images.. When I open the email it's all appearing fine but after few seconds the page gets begger and only half of it appears and I can't see the other half no matter how much I scroll.. I'm om ios5.0.1 now but I' [More]
Hey everyone, I have the following wierd thing happening. I shut my computer down, on which I am using Gnome with German language settings - everything worked fine and except for browsing the net I did not do anything that session. After 30 min I sta [More]