Hello,
I have a request to setup a calculation to provide an answer on a task plan checklist. We are looking to get a % answer based off of 2 measurement verses a standard. I have a checklist line for the first measurement, then the next line is the second measurement. For the third line I need to take the first reading and subtract the second and then divide by the second and then based on a set measurement get a percentage. Has anyone attempted something like this or is it even possible?
Thanks John C.
Hey John!
Something like this is possible, but it may be tough to do it in exactly the way you are thinking of (for example, inserting a value into the third checklist item based on the first two). But, it is possible to use the first two checklist items to get a value based on another standard value like you mentioned. What would you be using this new value (the percentage) for? For example, if you want to just use it for historical purposes, the way this is accomplished might be different than if you wanted to create a work order based off of the percentage.
Thank you,
Owen Daugherty