Wrong results and appearing negative

  • Resolved fabioa

    (@fabioa)


    3 years, 9 months ago

    There are two steps to generate the result:

    Original equations:
    Step1 = 1.7XX-0.07XX*LOG(sum of values) = RESULT_X
    Step2 = EXCEL FORMULA = [(4.9X/RESULT_X)-4.X]*100

    CFF equations:

    Step 1:
    1.17xx-0.07XX*LOGAB(fieldname6+fieldname5+fieldname4+fieldname3, 10)

    Step 2:
    (4.9X/FIELDNAME_STEP_1)-4.X*100

    I have already modified this equation several times, but results continue to appear with negative digits. How can I solve?

    • This topic was modified 3 years, 9 months ago by fabioa.
    • This topic was modified 3 years, 9 months ago by fabioa.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @fabioa

    If they are two separated calculated fields, for example, fieldname23 and fieldname32 and the equation of the fieldname23 is:

    1.1765-0.0744*LOGAB(fieldname6+fieldname5+fieldname4+fieldname3, 10)

    The equation of the fieldname32 would be:

    4.95/fieldname23-4.5*100

    If you want to implement everything as part of the same equation it would be:

    4.95/(1.1765-0.0744*LOGAB(fieldname6+fieldname5+fieldname4+fieldname3, 10))-4.5*100

    Best regards.

    Thread Starter fabioa

    (@fabioa)

    I tested the shapes you asked for, and even then the results are still negative

    See how images of the equations in the CFF and the results, must be some simple error that is happening.

    see the images:

    STEP 1 https://prnt.sc/13fxqnq
    STEP 2 https://prnt.sc/13fxtnw
    RESULT https://prnt.sc/13fxovg

    Plugin Author codepeople

    (@codepeople)

    Hello @fabioa

    I’m helping you to transform your original formulas in the plugin equations, but the original formulas is your work.

    In your original entry you are talking about these formulas like a same equation:

    [(4.95/RESULT_X)-4.5]*100

    and

    (4.95/FIELDNAME_STEP_1)-4.5*100

    But they are different.

    If you want to implement the first of the formulas the equation would be:

    (4.95/fieldname23-4.5)*100

    Best regards.

    Thread Starter fabioa

    (@fabioa)

    I redid the calculations, it was my mistake.

    Yes, it worked!

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Wrong results and appearing negative’ is closed to new replies.

Tags