Skip to Content
0
Former Member
May 07, 2010 at 09:30 AM

number of days

40 Views

Hi,

We have the following columns in the report

calmonth, customers(or agents), quantities ordered:

04/10 - Customer A - 1000

- Customer B - 800

- Customer C - 900

05/10 - Customer A - 1200

- Customer B - 850

- Customer C - 950

Now the requirement is we need to calculate the average per day quantities. i.e

calmonth, customers(or agents), quantities ordered, Avg per day

04/10 - Customer A - 1000 - 1000/30(days in April)

- Customer B - 800 - 800/30

- Customer C - 900- 900/30

05/10 - Customer A - 1200 - 1200/31(days in month)

- Customer B - 850 -850/31

- Customer C - 950 - 950/31

The calmonth is a variable at selection screen that user enters the range. I think that i need to write a formula variable and calculated Keyfigure. But i am not getting the logical flow of the solution. Will someone please suggest me and give your valuable inputs..

Thanks.