LOG10

  • Resolved georgiosm

    (@georgiosm)


    1 month, 2 weeks ago

    Hello, does the plugin allow for LOG10 calculation? I am trying to create the U.S. Navy Body Fat Formula which for men is:

    Body Fat % = 86.010 × log10(waist – neck) – 70.041 × log10(height) + 36.76

    Into the plugin as follows, but it does not work

    ROUND((86.010 * LOGAB(fieldname13 – fieldname7, 10)) – (70.041 * LOGAB(fieldname6, 10)) + 36.76)

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @georgiosm

    The issue is simple. You are using a dash symbol instead of minus symbol. The correct is:

    ROUND(86.010 * LOGAB(fieldname13 - fieldname7, 10) - 70.041 * LOGAB(fieldname6, 10) + 36.76)

    I removed the extra parenthesis because they are unnecessary.

    Best regards.

    Thread Starter georgiosm

    (@georgiosm)

    Oops! Rookie mistake! Thank you very much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.