Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to refer to a single data point in an alternate state?
For example, if I want to sum something up on an alternate state then it would be something like
=sum({Alternate State} revenue)
but what if I want to address it without a sum function, such as {Alternate State} revenue?
Thanks!
if there is only one value available in the field, you could use only(). Max()/Min()/Minstring() would also look for a single value
thanks for your suggestion Daniel - so I assume there's no way to extract a single data point in an alternate state without a function being involved (min, max, only, sum, etc.)
As long as you are dealing with values in fields you need some kind of function to identify this single value. But you could also set a variable in the scripting and use this in the frontend.
Maybe describe a bit whats your situation (input data/structure) and what you would like to achieve what is currently not working