Calculations on hours ?
I need to do a cell level calculation, if i do that in bex i cannot incorporate in webi based on the limitation. So i am trying to do that in webi level. The problem i am facing is i have a bex output where the calculation is based on hours. Take a look at the output below in bex.
When i take the same report to webi report it displays as same, now i need to sum up the hours here based on the "IDEAL TIME FOR REASONS". How to achieve this in webi. Appreciate your help on this.