Hi All,
This might be simple but I’m struggling to make it work and need some help please help me to resolve my issue.
The requirement is I need sum a column and divide with sum of another column and display it over quarter.
I have attached sample app and excel for your reference.
In the attached excel I just need to divide
Column L (Total actuals)/column G (Total Issues) and display across quarter as shown in the attached qvf.
The issue I when did the sum and division I’m getting wrong numbers
For example, for 2015-Q2 in the app attached the value is 0.13 – which is wrong
Expected result for 2015-Q2 sum of column L( 96)/ sum of column G (1481) = 0.064
Thank you,
ramya
