Case Statement for finding records that are between two numbers

[Hiperf]

I need to flag records that are either 15% or 30%. The first WHEN argument works, but the will not verify when the second argument is added. Error "near ("

CASE 
WHEN SUM([@calcfield:4])/AVG([@calcfield:7]) <=.015 THEN '15%'
WHEN SUM([@calcfield:4])/AVG([@calcfield:7]) <=.03  AND >=.016 THEN '30%'

ELSE ''
END

[CoopperBackpack]

Hello @Hiperf,

As I understand, you use this formula in Totals & Aggregations.

It looks like one condition is missing.

Please test this one:

CASE 
WHEN SUM([@calcfield:4])/AVG([@calcfield:7]) <=.015 THEN '15%'
WHEN SUM([@calcfield:4])/AVG([@calcfield:7]) <=.03  AND SUM([@calcfield:4])/AVG([@calcfield:7]) >=.016 THEN '30%'

ELSE ''
END

Hope this helps.

[Hiperf]

Thanks Coopper, that worked!

[cheonsa]

Hi!

For more details about the formula, you may check this howto article: https://howto.caspio.com/function-reference/

Most of the functions available in Caspio are listed here.