Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression of sum:
sum({$<[VOCE COSTO]={'G&A','LABOUR COST','DDA','TOT FIXED COSTS TRADING'},COMPANY-={'SPA'},ANNO={'$(VANNOCOL1)'}>} MISURA)
+sum({<COMPANY={'TOTAL G&A'}>}
aggr(sum({$<[VOCE COSTO]={'G&A'},COMPANY-={'SPA'}, ANNO={'$(VANNOCOL1)'}>} MISURA)
,[VOCE COSTO]))
+sum({<COMPANY={'TOTAL LABOUR COST'}>}
aggr(sum({$<[VOCE COSTO]={'LABOUR COST'},COMPANY-={'SPA'}, ANNO={'$(VANNOCOL1)'}>} MISURA)
,[VOCE COSTO]))
+SUM({<COMPANY={'TOT FIXED COSTS TRADING'}>}
aggr(sum({$<[VOCE COSTO]={'G&A','LABOUR COST','DDA'},COMPANY-={'SPA'}, ANNO={'$(VANNOCOL1)'}>} MISURA)
,[TOTAL_GROUP]))
cand I want to trasform it in inputsum but Changing sum in input it doesn't works.
Please help me!
Thanks
It doesn't works!
is there a way to trasform the expression
sum({$<[VOCE COSTO]={'G&A','LABOUR COST','DDA','TOT FIXED COSTS TRADING'},COMPANY-={'SPA'},ANNO={'$(VANNOCOL1)'}>} MISURA)
+
sum({<COMPANY_COSTI_FISSI={'TOTAL G&A'}>}
aggr(
sum({<COMPANY_COSTI_FISSI={'TOTAL G&A'}>}/{$<[VOCE COSTO]={'G&A'},COMPANY-={'SPA'}, ANNO={'$(VANNOCOL1)'}>} MISURA)
in a unique sum??