what's wrong with this formula...

[#1]

Hello All,

am sorry if am asking the basic thing, but this formula doesn't seem to be working..

=sum({$<[Qtr-Num]={$(#vLastQtr)}>}Total)

vLastQrt is a Variable where it picks the prev quarter from the current selection.

Please need some one's help here urgently..

Thanks & Regards,

Venkat T

[sreenivas · Accepted solution]

Try this

=sum({$<[Qtr-Num]={=$(Only([Qtr-Num])-1)}>}Total)

[#3]

Hi Srinivas,

Thanks for your reply, but still it's not working.

am attaching my solution file for the reference,please need your help.

Thanks,

Venkat T

[sreenivas]

Please find the attachment

[#5]

Hi Srinivas,

Thanks for your help, this works with Quarter-Num selections, but i cant have Quarter-Num list box in my solution.i have to manage this to work with Quarter selection or it would be great if it can be acheived with Quarter it self(as it is in the text format am not able to perform the math operations)...

Quarter-Num and Quarter are interlinked(Quarter-Num is nothing but gives the num of quarter what we have in the data in desc order)

Hope you understand my situation.Please need more suggestions.

Thanks ,

Venkat T

[sreenivas]

Try This may help you on click of quarter

=Sum({$<Quarter=,[Qtr-Num]={$(=Only([Qtr-Num])-1)}>} Total)

[#7]

Hey Sreenivas that works, thankyou so much for your help...

Thanks & Regards,

Venkat T