I have a calculation and I am trouble having writing it.
I have two fields both with values.
field 1 with values A, B and C
field 2 with Yes or no.
so the field 3 should be calculated as
if field 1 = B
and field 2 = Yes
then field 3 = (count of all records in a database with field 2=no)/(count of all records in a database with values with field 1 = B)
Is this possible