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
Skip to content
  • Register

    • IFThen condition in Freeform Reports

    edited Feb 25, 2025 8:44PM in EPM Platform and Freeform 6 comments

    Summary:

    Need to replicate Excel IFS function in Freeform.
    IFThen does not seems to be working as TrueParameter or Falseparameter does not seems to accepting formula.

    Content (please ensure you mask any confidential information):

    Requirement is while calculating a percentage, to use reverse a sign of final result when the denominator if negative
    Excel function below have to be used in Freeform:

    =IFS(B1=0;IFS(A1=0;0;A1>0;1;A1<0;-1);B1<0;-(A1-B1)/B1;B1>0;(A1-B1)/B1)

    Version (include the version you are using, if applicable):

    Service: Enterprise Performance Management Enterprise Cloud

    Business Process: FreeForm

    Version: 25.02.92


    Code Snippet (add any code snippets that support your topic, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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