Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a table that has the dimension Month_Year and Expression with a formula.
The formula is an expression that (a+b) / c
a and c data is updated daily on our system and b is updated every monday.
Is there any codes that I can do to ensure that the current month (not the historical months) will only compute based on every monday?
saying that today is wednesday, the figure is still on latest monday instead of today as it will dilute the % away.
May be like this.
Hi,
Try like this
=Sum({<DateDimensionName= {'<=$(=WeekStart(Max(DateDimensionName)))'}> } a)
The above expression will give you the sum of a until Monday of current week.
Regards,
Jagan.