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.