on 01-02-2014 10:10 AM
Hi,
Kindly let me know How to implement below calculations in BEX Query Designer.
Need to calculate Daily Sales Rate for current month, number of days will change based on system date. |
Year over Year % is calculated in 2 ways: 1 month (current month vs last year same month average daily sales rate) or 3 month average (Current month +prior 2 months vs same period last year) |
Thanks,
Siva
By using Bex standard variables we can achieve .
current month : 0CMONTH
last year same month : 0CMLMLY
if possible , share some sample data with scenario's for detail explanation either possible or not.
Regards,
Seshu.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please explain the same with some proper example for more understanding on it.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.