Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I write the expression :
SUM({<[Forecast Fiscal Month] = {'$(=([Forecast Fiscal Month],-1))'}>}[Stag Forecast Units])
Put single cots like
=SUM({<[fis_month] = {'$(=Max([Forecast Fiscal Month])-1)'}>} [Stag Forecast Units])
If you use this
SUM({<[fis_month] = {'$(=(Month(Addmonths(Forecast Fiscal Month,-1)))'}>}[Stag Forecast Units])
use date field and what is your dimension
SUM({<[fis_month] = {"$(=(Month(Addmonths(YourDatefieldHere,-1)))"}>}[Stag Forecast Units])
and use double cots
SUM({<[Forecast Fiscal Month] = {"$(=Date(AddMonths(Max([Forecast Fiscal Month]),1),'MMM YYYY'))"}>}[Stag Forecast Units])
My Sample Model attached.
PFA ...
The sample Model...
PFA ...
The sample Model...
PFA ...
The sample Model...
I understood that basing on some filters u should calculate sum. I had a similar situation earlier and I solved it using this expression. I think your req is similar to what I had earlier,please change your code in accordance with the one I pasted below. Here newyear,a field, has a filter and newmonth,another field, has 3 filters. work on it.Place the quotes properly. Hope it helps.
sum
({<newyear={'$(=max(newyear)-1)'},newmonth={'$(=Month(AddMonths(max(Dates),3)))','$(=Month(AddMonths(max(Dates),2)))','$(=Month(AddMonths(max(Dates),1)))'}>}Sales)
What you explain is not what is there in your application; field values are not similar. However, if you can brief about your expected result, might help us help you.
Hi Suvechha,
Try creating one inline table, this will be used in assigning numbers to [Forecast Fiscal Month] field because if you try in text box also max([Forecast Fiscal Month]) it won't come because [Forecast Fiscal Month] is text.
Please let us know if it works.
Thanks
Suhas