Jump to content
  • 0

CASE Statement After Aggregated formula


Patrick0329
 Share

Question

Hi!

Is it possible to put Case statement after the calculated aggregated formula in Data pages. I use tabular search result  what I want is I wan to place statement after the computed General Average like ( "Failed", "Retained", "Conditionaly Promoted", "Promoted", ect.) depending on the computed General average.

My aggregate formula is
Round(AVG, 0)

I am trying to add Case statement but it doesn't work.

Round(AVG, 0)

 

CASE

WHEN......

ELSE

END

If it possible please help.

image.png

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi Patrick, quite not sure of what you are trying to accomplish but, If your are trying to to put a CASE  WHEN statement on an aggregation field, then it is possible. I created a sample scenario below and it shows the valid pop up box.

image.png.caa65ecee9d36b7b36a2030a434d49a1.png

Link to comment
Share on other sites

  • 0
On 6/19/2022 at 4:21 PM, Patrick0329 said:

Hi!

Is it possible to put Case statement after the calculated aggregated formula in Data pages. I use tabular search result  what I want is I wan to place statement after the computed General Average like ( "Failed", "Retained", "Conditionaly Promoted", "Promoted", ect.) depending on the computed General average.

My aggregate formula is
Round(AVG, 0)

I am trying to add Case statement but it doesn't work.

Round(AVG, 0)

 

CASE

WHEN......

ELSE

END

If it possible please help.

image.png

Hello!

Based on what I understand, you would like to display "Failed", "Retained", "Conditionaly Promoted", "Promoted", etc, based on the General Average.  I tried to replicate it on my end and this is how you should do it: 

5682695

 

You can apply more condition in the CASE WHEN Statement.

 

Hope this helps.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...