on 10-15-2015 2:21 PM
Dear Experts,
I am facing difficulties while formulating the MACRO for particular case given below,
I have attached two images showing the dummy Planning Book data & MAX function inputs
We need to calculate Baseline forecast as max value of ( ACTUAL SALES QTY M 09.2015 ) & ( L3M AVG SALE QTY ).
Expected output of Macro was 135, but system is suggesting some random value.
How to compare both the values at cell level or any other function can be return the max considering both cell only.
Regards,
Deep Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deep,
You mentioned to calculate max value of ( ACTUAL SALES QTY M 09.2015 ) & ( L3M AVG SALE QTY ) but In the screenshot both the rows are showing same name - L3M AVG SALE QTY. - Please check.
Regards,
Alok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.