Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
Can someone please tell me why is the following expression not working in my pivot table ?
SUM({<DAYS_LEFT={">0"}>}$(vNRP))
Hi.
What is the definition of vNRP
May be try like this
SUM({<DAYS_LEFT={">0"}>}(vNRP))
Regards
ASHFAQ
Thanks Asfhaq
What u suggest does not work
but when I write $(vNRP) in the expression it works
vNRP=SUM(PREMIUM)-(SUM({$<REINSURER-={'RI FUND'}>}RI_PREMIUM))+SUM({$<REINSURER-={'RI FUND'}>}RI_COMM)-SUM(COMM)
Pls check and help
make sure your filter DAYS_LEFT={">0"} returns any data, you can test with DAYS_LEFT in the dimension and $(vNRP) in the expression
Hi Upali,
Try the same expression in a straight chart and check whether its working or not.
SUM({<DAYS_LEFT={">0"}>}$(vNRP))
Regards
Jyothish KC
remove the label of the expression with SUM .... in the pivot table
hover your mouse over the label and let we know what you see