Calculated Field loses Percentage Format

ChrisGaffan
ChrisGaffan Member
in Beast Mode 
CASE

WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1'

WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received / Weight (MIN))

WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units Received / Weight (MAX))

END

The THEN '1' seems to be breaking the ability to display the resulting column as a %. Even when the format is set to Percentage, the column appears a follows.

image.png

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Instead of using the string '1' just use the number 1.

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Instead of using the string '1' just use the number 1.

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

Categories