EQUATION EDIT

  • Resolved Graicifyd

    (@graicifyd)


    4 years, 4 months ago

    I have expressed this equation as 

    POW(POW(1+(fieldname16/fieldname33),1/fieldname35-1),fieldname35)-1

    where fieldname16=P. fieldname33=A and fieldname35=q,

    but I keep on getting a wrong answer. Please could you help me in correcting my expression?

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

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

    (@codepeople)

    Hello @graicifyd

    No, your equation is incorrect. You are grouping fields in the wrong way. The correct would be:

    
POW(POW(1+fieldname16/fieldname33,1/fieldname35)-1,fieldname35)-1

    Best regards.

    Thread Starter Graicifyd

    (@graicifyd)

    Thank you so much.

    Thread Starter Graicifyd

    (@graicifyd)

    Please could you also help confirm if this is correct?

    log[ 1 + (1/N) ] / log2

    Expression:

    LOG(1+(1/fieldname36))/LOG(2)

    fieldname26 = N

    Thanks in advance.

    Plugin Author codepeople

    (@codepeople)

    Hello @graicifyd

    The answer is …depends…

    If you want to get the log base 10, you cannot use the LOG operation because in javascript the LOG operation returns the logarithm base “e”. If you want to calculate the logarithm base 10, you should use the LOGAB operation distributed with the plugin: LOGAB(X, Y) returns the logarithm of X base Y, in whose case the operation would be:

    
LOGAB(1+(1/fieldname36), 10)/LOGAB(2, 10)

    All these operations are described in the documentation page of the plugin:

    https://cff.dwbooster.com/documentation#mathematical-module

    Best regards.

    Thread Starter Graicifyd

    (@graicifyd)

    Thank you so much for your help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘EQUATION EDIT’ is closed to new replies.