Calculated field dependencies

  • Resolved emilyj2122

    (@emilyj2122)


    5 years, 8 months ago

    This is my equation…

    (0.957 * LOG(fieldname2) + 0.378 * LOG(fieldname7) + 1.120 * LOG(fieldname5) + 0.6431) * 10

    Trying to figure out how to make it so if fieldname2 is < 1, a value of 1 is inserted in the equation instead. However, if fieldname2 > 1, that is the value that is calculated. Im new to using calculated fields. Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    5 years, 8 months ago

    Hello @emilyj2122

    The LOG operation is the natural logarithm (base “e”). If you want to calculate the logarithm base 10, you should use the LOGAB operation, where the second parameter would be the base. So, in this case, the equation would be:

    
(0.957 * LOGAB(fieldname2, 10) + 0.378 * LOGAB(fieldname7, 10) + 1.120 * LOGAB(fieldname5, 10) + 0.6431) * 10

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Calculated field dependencies’ is closed to new replies.