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. First post so be gentle as I'm not sure that this has been covered. I bought a Nokia Lumia, and suffered from the battery issue. I've just been given a replacement, and all is good. However, when I lock the homescreen after about 5 minutes the ph [More]
What session to pass to nxBlink() NI-XNET function ? I tried to pass sessions obtained from: - nxCreteSession(..., nxMode_FrameInStream, ...) - nxCreteSession(..., nxMode_FrameOutStream, ...) But I get error. The nxBlink() help only says use "The XNE [More]
Hi All, If you scroll down you will see a thread I started about losing my preferences and permission to my home directory after trying to change the name. I have now lost all preferences to do with Mac mail and need NEED to retrieve my old e-mails t [More]
Hi guys I am new to photoshop and photography both. I bought a new PC yesterday with 4K LG display. The PC has gigabythe 9600 display card with 2GB RAM on it. Intel i7 quad core cpu 4 GHz, 16 GB RAM, 250 GB SSD, 1 TB HDD 7200 RPM. REst is on the boar [More]
I am starting to tinker with Flex 4 and I am having trouble trying to load a style swf file.  I have a css file that looks like this @namespace s "library://ns.adobe.com/flex/spark"; s|Application {     background-color: red; which I compiled to [More]
When I import a folder containing master images which I've already saved as PSD files, for 90% of them I get an error saying basically that LR couldn't import the PSD files and that I should re-save in photoshop with maximize compatibility turned on. [More]
Hi All, We are using attachment functionality in R/3 System & we have a requirement that the output associated to that invoice should be attached to the same invoice as a PDF format, can this be achieved in simpler ways. I am looking more at standard [More]
About five months ago the workstations in our network started stalling at the Welcome Screen. Our fix is to restore back to the most recent restore point. This has worked (KOW) without incident. After reading many posts about the subject, and impleme [More]
I have a lot of old 110 and disk negatives. Is the a way to scan them or an attachment I can get for my C8180?Hello bigal18, I understand that when you try and scan from your Officejet 6600 you would prefer to scan negative to positive. Unfortunately [More]
Greetings would someone be able to clarrify please what direction Cisco is taking in regards to the SMB switching product line as i am starting to get somewhat confussed. From my estimation we currently have the following available for the SMB market [More]