Set Analysis: syntaxes

diana_ — Sat, 16 Nov 2024 20:41:50 GMT

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

Re: Set Analysis: syntaxes

sunny_talwar — Mon, 10 Jun 2019 12:35:11 GMT

May be try this

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

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

topic Set Analysis: syntaxes in App Development

Set Analysis: syntaxes

Re: Set Analysis: syntaxes