Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sharing Info: String Compare in Planning - @CalcMgrCompare function

edited Mar 12, 2020 8:25AM in Planning 5 comments

Summary

Execute a set of statements based on the Variable/Prompt Value (String Compare)

Content

Hi All

I found something interesting and want to share with all of you.

We have a requirement in Planning to execute a set of statements based on the current month Variable/Prompt Value.

Using Calc Manager function “@CalcMgrCompare”, we can compare two strings.

Below is the sample code:

====================================================================

IF(@CalcMgrCompare(@NAME(&Var_Curr_Mnth)), @NAME("Jan"), @_true))

<Statement1>;

ELSE

<Statement2>;

ENDIF

====================================================================

Version

EPBCS - Latest

Code Snippet

IF(@CalcMgrCompare(@NAME(&Var_Curr_Mnth)), @NAME("Jan"), @_true))

<Statement1>;

ELSE

<Statement2>;

ENDIF

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!