Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I use the following expression to calculate all incomming pallets that we received before the selected date.
=sum({$<%Date = {"<$(=min({$} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)
This is working perfectly, but now want to integrate this graph into a different report and therefore I have to use an alternate state.
But after this the formula doesn't seem to work anymore. Who can tell me what I'm doing wrong?
My new formule after alternate state (=StateB) :
=sum({StateB<%Date = {"<StateB(=min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)
My result is always 0.
Try this
=Sum({StateB<%Date = {"<$(=Min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)
Try this
=Sum({StateB<%Date = {"<$(=Min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)