Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
Try this
Sum({<DATA_IN = {"=Aggr(Max(DATA_IN), COD_PUNTO)"}, STATO_OUT = {'CESSAZIONE', 'RECESSO'}>} CONSUMO_TOT_ANNUO)
Try this
Sum({<DATA_IN = {"=Aggr(Max(DATA_IN), COD_PUNTO)"}, STATO_OUT = {'CESSAZIONE', 'RECESSO'}>} CONSUMO_TOT_ANNUO)