Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Having a little issue with this: I need to keep my company total no matter what the user selects. I will also have to publish using a loop and reduce and keep the company total of 5000 in each model from the reduce. Any ideas? Level 1 is the company and Level 2 is the region.
Company Region %
North 5000 2500 50
South 5000 2000 40
East 5000 250 5
West 5000 250 5
Here is the calculation I am using;
Max((aggr(Sum(TOTAL{<Level2=,Level3=,Level4=,[PC Desc]=,FISYR = {$(=$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1),Level1)))
May be explain more your intend to show? So that we may understand to trigger the issue
To overcome the issue, you can create an additional field in the script having company total across all regions. Try like:
Input:
Load
*
From <>;
join
Load
Region,
Sum(Sales) as CompanySales
Resident Input Group By Region;
Now even if you reduce and distribute the application region wise, all your regions have CompanySales individually.
plss attach sample file.
Is it u just want sum of company which should nt act as per selection.
Sachin