Calculating different values depend choosing different values in listbox

[Anonymous]

Good day!

In my model i load data from excel file.

Then i calculate sum of fields (Weight, Volume l.) in one expression depend choosing value in list box.

When i choose 'Weight' - it's working.

But when i choose 'Volume l.' - calculating expression is not working.. I think, it's connected with 'space' in name of field Volume l.

Can anyone solve this problem?

[MK_QSL]

Use below expression

=IF(GetFieldSelections(Title)='Weight', SUM(Weight) , SUM(Объем))

[ankit777]

try like this

[Anonymous]

Thanks.. but i need use expression w/o condition with if construction

[ankit777]

Then try like this

[Anonymous]

Sorry, but i need to calculate both of values in ONE expression, using variable value.

It's main idea of my task.

[ankit777]

can u rename this field Объем to Volume l.? Then your original file will give correct solution.

[Kushal_Chawda · Accepted solution]

Please see the attached file.

Your approach is correct but just required little modification in variable

[Anonymous]

No, it's not working

[Anonymous]

Thank you!!!