Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Within a chart, I would like to build an expression that will pull back the sum of the most recent value. I am trying to pull back using max(Date) logic but am failing. Any ideas?
This is what I have so far....
=sum(if(Date=max(Date),[Value(USD)],0)
Many thanks.
You need to put the date in Set Analysis, something like this:
Sum{< Date = {'=Max(Date)'} >} [Value(USD)])
For more information, refer to
You need to put the date in Set Analysis, something like this:
Sum{< Date = {'=Max(Date)'} >} [Value(USD)])
For more information, refer to
Do you want the result for the Max value across the whole dashboard or Max date on certain dimension/s?