Set Analysis: syntaxes

[diana_]

Hello,

 In my data column Side has values 1, 2 and 3, for all the variables I would like to retrieve data that has side either 2 or 3, so I tried these 2 formulas, but they don't work. If I write just [Side]=2 without '>' sign, it gives value, but I need values >=2

Sum({$<[Label name]={'Total Consumption (MWh)'},[Side]>=2} >} Value)

Sum({$<[Label name]={'Total Consumption (MWh)'},OR([Side]=2,[Side]=3)>} Value)

Could you please help?

Thanks

Best regards,

Diana

[sunny_talwar · Accepted solution]

May be try this

Sum({$<[Label name] = {'Total Consumption (MWh)'}, [Side] = {">=2"}>} Value)

or

Sum({$<[Label name] = {'Total Consumption (MWh)'}, [Side] = {'2', '3'}>} Value)