PiWeb, how to separate True Position data.

[[Ri...]]

My customer is looking to separate the data for when True Position is using Tolerance Modifiers in PiWeb reporting.
Currently: PiWeb adds the modifier value to the tolerance value.
What they want: The True Position tolerance will remain as entered, add a column to show what the modifier value is.

Is this possible or already available?

[[Jo...]]

Rick, I experimented with this and never got a response. Here is what I discovered. My code isn't quite there, but maybe you can fix it. Make your viewable area large enough to see multiple lines for test purposes. This code produces these results..
I was trying to get the min/max of the list and subtract the two to do exactly what you requested. It is only valid for last part, so no good for table reports. If you can crack the syntax to select ONE out of that list, you got it.

That screenshot is multiple lines, each box contains Base, and modified tolerance values for that occurence

toler.JPG

[[Ri...]]

As an example, I would like to achieve something like this image.

Example.JPG

[[Ri...]]

Please sign in to view this quote.

What version of Calypso are you working in?

I'll see what I can come up with, but I want to make sure it's in a version you can use.

[[Jo...]]

Please sign in to view this quote.

Richard, if you can help with operator, I think this will work. It displays the "minus" instead of subtracting difference.

output.JPGdifference.JPG

[[Ri...]]

Please sign in to view this quote.

Are you just wanting a column of total tolerance?

${abs(${Qdb.Characteristic(2113)-Qdb.Characteristic(2112)})}

This will give you that.

[[Jo...]]

Please sign in to view this quote.

Got it. See the instruction pdf in my previous post. Link the two text elements and then you can use them as variable with math operator.

[[Ri...]]

Please sign in to view this quote.

John,

What are you using to pull the Base Tolerance?

${List.Min(Qdb.CharacteristicAttributes(2113))}

${List.Max(Qdb.CharacteristicAttributes(2113))}

both pull the same value for me.

[[Jo...]]

Please sign in to view this quote.

So first off, I made a Detailed template row for positions only.
If you List.sort you can view all numbers for 2113. It won't be populated with multiples unless it has a modifier. See here:

So ListMin will be "base", ListMax will be "modified" List Sort wil be "all".
I had to use the linked Text boxes, because math operators aren't supported if you type in the field. I tried 2+2= and got "2+2=" So the linked Text box is the workaround. I subracted Min from Max to get "Bonus"

list.JPG

[[Ri...]]

Please sign in to view this quote.

Can you send me a copy of your ptx file? I'd love to reverse-engineer it. This is great stuff.

[[Ri...]]

Please sign in to view this quote.

Calypso 2019 (v6.8.x)

[[Ri...]]

Please sign in to view this quote.

I (Customer) wants a column showing the Modifier value only for True Positions and possibly Profiles.
They have two complex custom templates (and PCM) they use, eventually I will attempt to apply any possible methods for testing.