Alternate state refer to a single data point

[#1]

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!

[danieloberbilli]

if there is only one value available in the field, you could use only().  Max()/Min()/Minstring() would also look for a single value

[#3]

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.)

[danieloberbilli]

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