0

How to count non-digital content and calculate the percentage

001

I want to count the completed quantity and calculate the percentage of completion. How can I do it? thank you.

5 replies

null
    • Support
    • 5 yrs ago
    • Reported - view

    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 + myfield2

     

    You 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

    • enric19810316
    • 5 yrs ago
    • Reported - view

    Which position should the formula be filled in? Thanks.

    • enric19810316
    • 5 yrs ago
    • Reported - view

    IMG_0300

    Which position should the formula be filled in? Thanks.

    • Support
    • 5 yrs ago
    • Reported - view

    Hi, 

    please put the formula in a formula field.

    Best, Jörg

    • cyan_silver
    • 5 yrs ago
    • Reported - view

    Thank you, Jörg

Content aside

  • 5 yrs agoLast active
  • 5Replies
  • 2071Views