This content has been marked as final. Show 4 replies
I am calculating sum(EBITDA) for one customer A .
I have Target Revenue column which is 1st column and then the Target EBITDA% which is in 2nd column.
At backend, I convert sum(Target EBITDA%)/100 as Target EBITDA%
Now I calculate 3rd column which sum(Target Revenue) * sum(Target EBITDA%)
Now in the above table sum is coming out to be 5.99 but this is not the total of all individuals rows which has 1.00.
How I get the correct sum?