CASE Statement After Aggregated formula

[Patrick0329]

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.

[Wikiwi]

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.

[Sivad]

Hi Patrick, you may also check this link to know more about aggregations: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/#:~:text=the label field.-,Aggregate Options,-Using the arrow

[cheonsa]

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.

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: 

 

You can apply more condition in the CASE WHEN Statement.

 

Hope this helps.

[cheonsa]

I just wanted to share this article with you as an addition to my earlier response: https://howto.caspio.com/function-reference/