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
Hi,
Please explain the same with some proper example for more understanding on it.
Regards,
AL
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
Add a comment