Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like:
ID Type
1 a
2 a
3 b
I have a chart that displays differently depending on what the latest entry in the above table was. So it might look something like this:
if( latest(Type) = a, SUM(something), SUM(something else)
My question is how do I get that Type value into the equation? Thanks!
Hi,
Try this:
if( Only({$<ID={'$(=max(ID))'}>} Type) = a, SUM(something), SUM(something else))
Hope this helps.
Best Regards!
Hi,
Try this:
if( Only({$<ID={'$(=max(ID))'}>} Type) = a, SUM(something), SUM(something else))
Hope this helps.
Best Regards!