Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking for some Set Analysis help. I need to sum Dimension A only for dates that are the Max Date of Value B - 30 days. Nothing I am finding helps, any ideas?
something like
Sum({<Max(Date_B)-30>} Value_A)
May be this?
Sum({<Date_B = {"$(=Date(Max(Date_B-30),'DD-MM-YYYY'))>} Value_A)
Or
Sum({<Date_B = {">=$(=Date(Max(Date_B-30),'DD-MM-YYYY'))<=$(=Date(Max(Date_B),'DD-MM-YYYY'))>} Value_A)
Neither works. returns "Error in expression"
Error was due to missing " but this still does not solve it question. both expressions do not work.
Do you want to sum Value_A where the Date_B >= Max(Date_B) - 30? or just Date_B = Max(Date_B) - 30?
Also, what is the format for Date_B field?
MM/DD/YYYY
Sum Value B for all days that equal Max(Date) - 30
Try this
Sum({<Date_B = {"$(=Date(Max(Date_B)-30, 'MM/DD/YYYY'))"}>} Value_A)
This worked, thank you!!