on 09-29-2015 6:18 AM
Hi Experts,
Would like to seek for your help what is the best way to create a macro where past and future periods are involved.
Ex.
For the current period computation
If period is from last month up to the past periods
KF3= (KF1 / KF2) *10
If period is current to future:
KF3 = (KF1/KF4)*10
Am just starting with macros. Thanks for your help.
Sincerely,
Ria
Hi Ria
I think you can perform the following calculation using iterations in the Macro step.
Please find below few screen shot where you can define different steps for respective horizon. Once you different steps, you can define each condition/calculation which will be performed for that horizon.
Please do let me know if this information helps you.
Thanks
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check you data view, if it´s in Monthly or weekly?
Please try to create the macro as I suggested above , you could also try Date-dependent flag.
If this already answer your question follow How to close a discussion and why
Thanks
Amol
User | Count |
---|---|
11 | |
4 | |
3 | |
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.