Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a expression which is filtered by a selection in field within alternate state.
The formula is as follows :
=Sum({COMPARATOR<Hour={"<=17"},[Store_id]=$::[Store_Id]>}[Sales])
It selects all sales for the day until 17:00 o'clock (store selection is optional).
The problem is that the hour selection should be dynamic rather than fixed (user interaction).
So, I figured out the formula like this:
=Sum({COMPARATOR<Hour={"<=MaxString({COMPARATOR}[Hour])"},[Store_id]=$::[Store_Id]>}[Sales])
And it'not working. I guess the syntax is wrong and QV could not evaluate MaxString({COMPARATOR}[Hour]).
Can you please help?
May be try this
=Sum({COMPARATOR<Hour = {"<=$(=MaxString({COMPARATOR}[Hour]))"}, [Store_id] = $::[Store_Id]>} [Sales])
May be try this
=Sum({COMPARATOR<Hour = {"<=$(=MaxString({COMPARATOR}[Hour]))"}, [Store_id] = $::[Store_Id]>} [Sales])
Hi Sunny,
Glad to see you around :-).
Thanks, it worked !