Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table which has 2 columns (Year Amount, Life Amount). These 2 are calculated columns based on the formula in Set Analysis.
Now I want to add the third column - Amount which shows either Year Amount or Life Amount based on Criteria. Could you please let me know how can we achieve this?
Thanks
You may need to use it in your measure
=sum({<FYMActDate.YearMonth={">=$(=date(addmonths(max(FYMActDate.YearMonth),-5),'YYYY-MMM'))<=$(=date(max(FYMActDate.YearMonth),'YYYY-MMM'))"}>}Amount)
I tried as Measure, its all coming as 0's
Can you share a sample where you are trying?
Please refer attached sample file
see the attached
I am sorry for the delay in responding to this. I got into something before I check this out. I will try this and keep you posted. Thanks a lot for looking into this.