0
How to count non-digital content and calculate the percentage
I want to count the completed quantity and calculate the percentage of completion. How can I do it? thank you.
5 replies
-
Hi,
you can use a formula like this for it:
let myfield1 := if text(Field1) = "Yes" then 20 end;
let myfield2 := if text(Field2) = "Yes" then 20 end;
myfield1 + myfield2You just need to adjust the formula to your field names and the amount your field (as I assume you have five, thats why I chose the 20 for each variable...).
Best, Jörg
-
Which position should the formula be filled in? Thanks.
-
Which position should the formula be filled in? Thanks.
-
Hi,
please put the formula in a formula field.
Best, Jörg
-
Thank you, Jörg
Content aside
- 6 yrs agoLast active
- 5Replies
- 2074Views