Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression like this-sum(MRP)/conv_rate.this holds good but the Sum is not visible on the top.
If I do Sum(MRP/Conv_Rate) sum is visible but calculation is wrong.
Can anyone suggest me how to get the first expression done with Total visible on the top of the pivot table.
Thanks,
Try
SUM(TOTAL MRP)/conv_rate
EOM | OH_Units | =Sum(Total MRP_Inv)/Conv_Rate_I_Inv |
Total | 198,177 | - |
06/30/2013 | 98,199 | $156,443.89 |
03/31/2013 | 99,978 | $171,338.52 |
To solve that problem using the function AGGR where you specify the dimensions that you are using.
I did use sum(Aggr(Sum(MRP)/Conv_rate,EOM)) but its only showing up total and when I expnad for all other dimensions on the chart it just shows zero.
Thanks,
Are there differents Conv_rate to a EOM?
In this Case, Can you use a min or max Conv_rate?
yes.One conv_rate per date.I cant take min or max because it varies as per date.
What is the SUM for, if you're aggregating MRP but not conversion rate? What is your intended grouping?