Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculating different values depend choosing different values in listbox

Good day!

In my test model i try calculate different values in one expression, which have the same name in listbox.

Is it possible to implement it?

For example, if i choose "Volume", my expression must calculate sum of volume, in other case - sum of weight.

There's model in attachment. !

1 Solution

Accepted Solutions
Siva_Sankar
Master II
Master II

You can use variable and use it in your expression, an other method. refer the attached.

View solution in original post

7 Replies
swuehl
MVP
MVP

You can use conditional expressions.

Siva_Sankar
Master II
Master II

You can use variable and use it in your expression, an other method. refer the attached.

Anonymous
Not applicable
Author

create a variable vMeasure=GetFieldSelections(Title)

then use expression sum($(vMeasure))

So that if you will have multiple values in list box and and select one it will work fine .

Thanks

BKC

Anonymous
Not applicable
Author

Many thanks))

Anonymous
Not applicable
Author

Thank you for your help!!

Anonymous
Not applicable
Author

Thanks.

Anonymous
Not applicable
Author

But if in table Main i Use dimension name with space, this way is not working.

See files in attachment