Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a filter PreviousMonth which gives me the Date range 2019-02-01 to 2019-02-28
However I need to make an exception to ignore this in an expression in order to get the sum value for yesterday (2019-03-04), which is the same as max(Date) in my application
=sum({<PreviousMonth=, Date={"$(=max(Date))"}>}value)
This doesn't work, anyone know why? I only get the value for 2019-02-28 with the above expression.
I cannot use {1} either as that ignores everything, i need to only ignore PreviousMonth. Any help would be appreciated
=sum({<PreviousMonth=, Date={'$(=max({<PreviousMonth=>}Date))'}>}ValueEUR)
Where do you use this , if you use this ina text box/kpi it shall give you the correct answer. If in a table you need to tell us what are the dimensions.
Could you provide test qvw?
here is sample provided
Just to reiterate:
I want the expression to ignore "PreviousMonth", when it's active, i.e. set to Yes.
So I want it to show the sum value for max(date), which is 2019-03-04, which is 8156185.05
But it shows the value for 2019-02-28, which is 9610818.95, even if i have PreviousMonth= in the expression.
=sum({<PreviousMonth=, Date={'$(=max({<PreviousMonth=>}Date))'}>}ValueEUR)