Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I am using the following expression as part of Set analysis to derive PT values for a month (it works)
Sum ({$<MonthExp={$(=Only(MonthExp))}>}PT)
When I try to deribe the prior month's values, I am using the following:
Sum ({$<MonthExp={$(=Only(MonthExp)-1)}>}PT) and instead of getting the previous month , i.e 'Mar' I am getting the value of 3 and not able to derive the prior month's values.
Please help.
Thank you
Using MonthNum really helped - Thank you very much
I have MonthNum in my column headings - is there any easy way to convert to the Month Name for presentation purposes?
I guess continue to use MonthExp for the expression label so that you continue to see the month.
Also make sure you understand that when you use MonthNum... Things become difficult when its Jan. So make sure you really want to use month instead of date.
Now if you got what you wanted, I would request you to close the thread by marking correct and helpful answers.
Best,
Sunny