AnsweredAssumed Answered


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