Dividing Fields in Set Analysis

[BPetosa]

Hello Everyone,

I am trying to only grab ID's where the quotient of 2 associated fields is less than 25%. I am trying this, but can't seem to get it to work.

count({<field1 / field2 = {"<.245"}>}ID)

Any help would be much appreciated.

Thanks,

Ben

[Arthur_Fong · Accepted solution]

Try this:

count(if(field1 / field2 <0.245,ID))