Adding row values

renjithpl — Thu, 25 Nov 2021 09:50:22 GMT

Hi All,

I have an output table like below:

I am expecting an output like below

but unfortunately I am getting a wrong output for Operations and Rates = 5.5.
its Summing Del and Area Rates (2.5 + 3) = 5.5 which is wrong.

Basically, I want to add the total of Del and Area Cash (50 + 300) =350 / Del and Area Hours (20 + 100) = 120 and the result should be 2.91 not 5.5

Thanks in Advance.

Renji

Re: Adding row values

renjithpl — Thu, 25 Nov 2021 15:14:57 GMT

Found a solution to this.. its giving the results as expected.

=if(unit_type = 'Operations' and Source = 'Rates',

sum({<Source={'Cash'}>} total <unit_type> Amnt)/
sum({<Source={'Hours'}>} total <unit_type> Amnt), Sum(Amnt))