Hi - I want to perform division on two custom checkbox fields in my reports.
If the checkbox == True then this should be equal to 1
If the checkbox == False then this should be equal to 0
Is it possible to do the following:
Checkbox1:Sum / Checkbox2:sum?
Hi @MMetros5,
Yes, this can be achieved with calculation properties: Create calculation and rollup properties
As a first step, you’ll have to translate True into 1 and False into 0. This could be done with a simple workflow. (If field 1 is equal to True, set field 2 to 1. If field 1 is equal to False, set field 2 to 0.)
Next, you would create a custom equation property that divides field 1 by field 2.
Let me know if you need further assistance. Hope this helps!