Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Right now I am using below expression:
Sum(Trad_UNREALIZED_PL) + If(Trad_PERIOD='P0',0,RangeSum(Above(sum(Trad_UNREALIZED_PL) ,RowNo()-1)))
And my question is when ever I select ex:Period=P1 then P0 and P1 should be displayed so P0 should be displayed always without disturbing the results.
Could some one please help me?
Thank you
means?? for each selection you want different periods to be shown??
can you please explain me what your looking for
For Ex:
If I select P1 then
P0
P1
and If I select P2 then
P0
P2
and If I select P3 then
P0
P3
Like this.
Thanks Avinash for helping me.
Hi Raj,
Please create a new field PeriodNo to stored numeric representation of the period column..
eg P1 = 1,P2 = 2 ......
and then used the set expression like
sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}yourcolumn) for Sum of Each Row
and
sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}B) + RangeSum( Above(sum({<PeriodNo={'<=$(=Max(PeriodNo))'},Period=>}B)))
for cumulative sum.
Regards
Nandkishor
Hi Raj,
After lot of R&D i found the soultion.
its dynamic use this expression:
if(GetSelectedCount(Product)=0,sum(AMOUNT),sum({<Product={'P0',"=Product=GetFieldSelections(Product)"}>}AMOUNT))
its working perfectly. Thanks for the innovative question it took almost 2 hrs
Hey if you got the answer please mark it as answered
Hi Avinash,
Let me test it.
Thanks for your help.
sure Raj, if you have any issue let me know
Hi Raj,
Did this issue got resolved??? or still any issues
Sorry Avinash, I couldn't get time to check this as I was stuck on other issues and even you helped me on those also.
I knew that you have spent much time on this issue, I can't forget it. I am sure that I will check this.
sure bro