Forum Discussion
Solved
Capping variance at 999%
Greetings good people! Please assist with capping the variance to a 999%. The reason for this is in some instances, the variance of MTD vs PY MTD is many digits eg 14628%. Instead, I would like i...
Please try:
spl MTD VAR% Gross Activation = VAR __BASELINE_VALUE = [spl MTD Gross Activation] VAR __VALUE_TO_COMPARE = [MTD Gross Activation] VAR __VALUE = IF ( NOT ISBLANK ( __VALUE_TO_COMPARE ), IF ( ISBLANK ( DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE ) ), VALUE ( "0.00" ), DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE ) ) ) VAR __RESULT = MIN ( __VALUE, 9.99 ) RETURN __RESULTBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
spl MTD VAR% Gross Activation = VAR __BASELINE_VALUE = [spl MTD Gross Activation] VAR __VALUE_TO_COMPARE = [MTD Gross Activation] VAR __VALUE = IF ( NOT ISBLANK ( __VALUE_TO_COMPARE ), IF ( ISBLANK ( DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE ) ), VALUE ( "0.00" ), DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE ) ) ) VAR __RESULT = SWITCH ( TRUE (), __VALUE < -9.99, -9.99, __VALUE > 9.99, 9.99, __VALUE ) RETURN __RESULTBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
