Beast mode

Options
MayaU_01
MayaU_01 Member
in Beast Mode

How I can limit my percentage calculate to be capped at 100% only for those calculations where its exceeds 100%, if not then it should show the below 100% values?

Tagged:

Best Answer

  • nmizzell
    nmizzell Contributor
    Answer ✓
    Options

    Min(1, `decimal value to be capped`)

    Then, on your formatting, display the number as a percentage.

Answers

  • nmizzell
    nmizzell Contributor
    Answer ✓
    Options

    Min(1, `decimal value to be capped`)

    Then, on your formatting, display the number as a percentage.

  • GrantSmith
    GrantSmith Coach
    Options

    In a beast mode you can do something like:

    CASE WHEN `value` >= 1 THEN 1 ELSE `value` END

    In a Magic ETL formula tile you can use the LEAST function:

    LEAST(`value`, 1)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MayaU_01
    MayaU_01 Member
    Options

    Thank you

Categories