cancel
Showing results for 
Search instead for 
Did you mean: 

How to implement below calculations in BEX Query Designer

siva_pidugu1
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member199945
Active Contributor
0 Kudos

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

anshu_lilhori
Active Contributor
0 Kudos

Hi,

Please explain the same with some proper example for more understanding on it.

Regards,

AL