Dividing Fields in Set Analysis

BPetosa — Sat, 16 Nov 2024 04:04:44 GMT

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

Re: Dividing Fields in Set Analysis

Arthur_Fong — Wed, 20 Nov 2019 02:54:40 GMT

Try this:

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