Division issue

ramyasaiqv — Thu, 07 Sep 2017 17:17:00 GMT

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

Re: Division issue

sunny_talwar — Thu, 07 Sep 2017 17:24:35 GMT

Try this

Sum([Total actuals])/Sum([Total Issues])

ramyasaiqv — Thu, 07 Sep 2017 19:05:56 GMT

Thank you very much Sunny.

Ramya