AnsweredAssumed Answered

Calculation

Question asked by garry107 on Apr 12, 2017
Latest reply on Apr 12, 2017 by siplus

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

 

Thanks,

Garry

Outcomes