Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » Calculations in Tiki tracker?
 
Thread actions
Print this page
  • Print all pages

    • Calculations in Tiki tracker?

    Posted by Jeffrey Frady posts: 75 United States

    I'm working on a new project using Tiki Wiki. I want to be able to track calibration records of air sampling instrumentation.

    I'm using a tracker to enter calibration values. Let's say the target value is 50.2 PPM. The instrument shows a response of 48.0 PPM. I'd like Tiki to be able to provide an output of the percentage deviation from the target.

    Target Value = 50.2 PPM (known value)
    Response Value = 48.0 PPM (known value)

    • Calculated Percentage Deviation = 4.38%* (calculated value)


    Can Tiki do this?

    Reads: 1031
    Posted by Jeffrey Frady posts: 75 United States
    Jeffrey Frady wrote:

    I'm working on a new project using Tiki Wiki. I want to be able to track calibration records of air sampling instrumentation.

    I'm using a tracker to enter calibration values. Let's say the target value is 50.2 PPM. The instrument shows a response of 48.0 PPM. I'd like Tiki to be able to provide an output of the percentage deviation from the target.

    Target Value = 50.2 PPM (known value)
    Response Value = 48.0 PPM (known value)

    • Calculated Percentage Deviation = 4.38%* (calculated value)


    Can Tiki do this?

    I'm reading through other posts and it looks like this can be done. I'm still working it out.


    This is basically the calculation I want to perform.

    Percent Error = ((Instrument - Reference) / Reference) × 100
    or
    ((f_27-f_24)/f_24)*100

    Posted by Bernard Sfez / Tiki Specialist posts: 8654 France
    Jeffrey Frady wrote:

    This is basically the calculation I want to perform.

    Percent Error = ((Instrument - Reference) / Reference) × 100
    or
    ((f_27-f_24)/f_24)*100


    Please check : https://doc.tiki.org/Calculations
    For your case it should be something like (to be tested)

    Copy to clipboard
    (mul (div (sub f_27 f_24) f_24) 100)


    My 2 cents, I prefer working with identifiable permaname and not the f_n' form (IE: "peopleAge").
    You may want to add rounding operation and some check in case a field is empty.

    Good luck

    Posted by Jeffrey Frady posts: 75 United States
    Bernard Sfez / Tiki Specialist wrote:

    Please check : https://doc.tiki.org/Calculations
    For your case it should be something like (to be tested)

    Copy to clipboard
    (mul (div (sub f_27 f_24) f_24) 100)


    My 2 cents, I prefer working with identifiable permaname and not the f_n' form (IE: "peopleAge").
    You may want to add rounding operation and some check in case a field is empty.

    Good luck

    I got the rounding function to work! Thank you so much. This is been a big help for my day job.

    Posted by Jeffrey Frady posts: 75 United States
    Jeffrey Frady wrote:

    I'm working on a new project using Tiki Wiki. I want to be able to track calibration records of air sampling instrumentation.

    I'm using a tracker to enter calibration values. Let's say the target value is 50.2 PPM. The instrument shows a response of 48.0 PPM. I'd like Tiki to be able to provide an output of the percentage deviation from the target.

    Target Value = 50.2 PPM (known value)
    Response Value = 48.0 PPM (known value)

    • Calculated Percentage Deviation = 4.38%* (calculated value)


    Can Tiki do this?

    Thank you! I got it to execute but I think there may be another issue. One of the values is an Item Link. The number that is going into the calculation is not the number that is in the Item Link.


    Update. It is using the Item Link's itemID number rather than the value listed.

    Posted by Jonny Bradley posts: 126892 United Kingdom
    Jeffrey Frady wrote:

    Thank you! I got it to execute but I think there may be another issue. One of the values is an Item Link. The number that is going into the calculation is not the number that is in the Item Link.

    Update. It is using the Item Link's itemID number rather than the value listed.


    Try specifying the ItemLink field as permanentName_text - not sure if that works in calculations now but definitely works in list etc plugins.