Set Analisys with OR

danosoft — Thu, 09 Aug 2018 07:38:09 GMT

Hi, i need to do a Set Analisys like this:

Sum({<DATA_IN={"=Aggr(Max(DATA_IN), COD_PUNTO)"},{STATO_OUT='CESSAZIONE' OR STATO_OUT='RECESSO'}>} CONSUMO_TOT_ANNUO)

where the first filter DATA_IN must be in AND with STATO_OUT, STATO_OUT in same time must be in OR like you see in example.

but this i write not work....

Re: Set Analisys with OR

sunny_talwar — Thu, 09 Aug 2018 10:46:10 GMT

Try this

Sum({<DATA_IN = {"=Aggr(Max(DATA_IN), COD_PUNTO)"}, STATO_OUT = {'CESSAZIONE', 'RECESSO'}>} CONSUMO_TOT_ANNUO)