Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Adding row values

Hi All,

I have an output table like below:

row cost center unit_type Source Amnt
1 posAA Del Cash 50
2 posAA Del Hours 20
3 posAA Del Rates 2.5
4 posAA Area Cash 300
5 posAA Area Hours 100
6 posAA Area Rates 3
1 posAA Operations Cash 50
2 posAA Operations Hours 20
3 posAA Operations Rates 2.5
4 posAA Operations Cash 300
5 posAA Operations Hours 100
6 posAA Operations Rates 3

 

I am expecting an output like below 

cost center unit_type Source Amnt
posAA Del Cash 50
posAA Del Hours 20
posAA Del Rates 2.5
posAA Area Cash 300
posAA Area Hours 100
posAA Area Rates 3
posAA Operations Cash 350
posAA Operations Hours 120
posAA Operations Rates 2.916667

 

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

renjithpl_0-1637833668148.png

Thanks in Advance.

Renji

1 Reply
renjithpl
Specialist
Specialist
Author

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))