on ‎2022 Jul 31 10:15 PM
How can I create a custom formula in a sac story where, if the % variance between plan and actual is greater than 999% then the formula should give "nm"?
I have tried to create this variance not as a calculated measure and the format of formula is not supported by SAP.
One would think that the SAP would do any calculation what is done in excel. These are very basic formula and are helptul for management reporting.
Anyone has any idea how to do this?
Request clarification before answering.
Actually I resolved this by adding a column after all my $ variance and there I build an multiple if conditions and it worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.