subtraction and division in pivot table

[arulsettu]

Hi,

     I am trying to do profit and loss statment. here in pivot doing row wise calculation using flags. my issue is when i try to subtract two rows i am getting same value for every rows. and for division also. when select particular lob it showing correct vale.

please check the sample app and suggest some idea. i am really stuck here

[sunny_talwar]

I am working on it still. Trying to understand your data and will let you know if I have question.

Best,

Sunny

[arulsettu]

Hi Sunny,

               Any solution for this

Thanks

[jagan · Accepted solution]

Hi,

Try like this, give expression as Test (For example) and give this expression

Above([Test], 16)/Above([Test], 18)

Hope this helps you.

Regards,

Jagan.

[arulsettu]

Hi Jagan,

          i tried like this

if([Clockwise Calculation]='nr',Above(sum({<TD_DRCR_FLAG={'D'},TBAL_CAL_MONTH=,TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield))))<=$(=max(datefield))"}>}TD_AMT_LC_1)-sum({<TD_DRCR_FLAG={'C'},TBAL_CAL_MONTH=,TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield))))<=$(=max(datefield))"}>}TD_AMT_LC_1),4)/

above(sum({<TD_DRCR_FLAG={'D'},TBAL_CAL_MONTH=,TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield))))<=$(=max(datefield))"}>}TD_AMT_LC_1)-sum({<TD_DRCR_FLAG={'C'},TBAL_CAL_MONTH=,TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield))))<=$(=max(datefield))"}>}TD_AMT_LC_1)),1)

but getting result is 1 for every row

can you please check what i am doing wrong

[arulsettu]

Hi Jagan,

               The code i tried is correct?

[jagan]

Not sure.  I think you are getting the same value, that is why when you are dividing you are getting 1.  Check this by giving one expression and see the number.

Regards,

Jagan.

[arulsettu]

the value is different but i am getting 1 only. i am doing some mistake. can i uplload the new app i tried

thanks

[jagan]

Hi,

I think it won't work since you are using the dimension.

Regards,

jagan.

[arulsettu]

any way to achive this jagan. i dont know how to do this.

plz suggest

Thanks

[jagan]

Previous solution not working?

Regards,

Jagan.