Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I really need help to simplifiyng the expresion, is a calculated expresion, but there are too many nested if´s and this makes it limited, becouse if in the future I add a new row in the field it won´t be included.
I attached the app is just one expresion in a pivote table.
I appreciate your help guys!!
Hi
Hope this expression will be helpful for you
=
sum( aggr(
IF(ACCOUNT_NAME = 'NOMINA_HRAS', sum({$<ACCOUNT_NAME = {'MINA_HRAS'}>}[Costo por hora]* [Hrs Reales]),SUM(Gastos))
,ACCOUNT_NAME,COCE_NAME))
+
sum({$<ACCOUNT_NAME = {"NOMINA_HRAS"}>}[Costo por hora]* [Hrs Reales])
Regards
Hi
Hope this expression will be helpful for you
=
sum( aggr(
IF(ACCOUNT_NAME = 'NOMINA_HRAS', sum({$<ACCOUNT_NAME = {'MINA_HRAS'}>}[Costo por hora]* [Hrs Reales]),SUM(Gastos))
,ACCOUNT_NAME,COCE_NAME))
+
sum({$<ACCOUNT_NAME = {"NOMINA_HRAS"}>}[Costo por hora]* [Hrs Reales])
Regards
Yes, It works excellent, Thank you chandashok, I really need it.
Have a good one, and thanks again!!