Date Calculation

[upaliwije]

Hi all

I have attached QV document where I have created a Pivot Table. But when I collapse Following fields

figure do not appear

Total Days, Days Left and Unused Amount.

But when I expand the table figure do appear. I want to show figures when fields are collapsed as well. Pls help me

[MK_QSL]

Change your expressions

SUM(TOTAL_DAYS)

SUM(DAYS_LEFT)

[upaliwije]

still the unused amount does not get calculated

[MK_QSL]

SUM(if(DAYS_LEFT>0,NRP,0))*(DAYS_LEFT/TOTAL_DAYS)

[upaliwije]

Thanks for you reply

• but still the unused amount remain blank. Pls try with my example and reply
• 
  

thanks

[sundarakumar]

This is bec when u r collapsing multiple values are returned for a single dimension entry, u should use an aggregate function to it like sum(), max(), etc...

-sundar

[upaliwije]

Could u please modify in my QV document and upload back

[sundarakumar · Accepted solution]

FPA. Please let me know if it is correct or u want some logic to be implemented on it.

[Anonymous]

here is it

[upaliwije]

Thanks all