Hi Joanna,
It appears that I spoke too soon. I am still having issues getting the asset group formula outputs to match the calculation values that are in the individual worksheets. They're different now and not all the same, but they do not match the values that I calculated in the asset specific worksheets. The only asset that matches is the first asset in my list.
I've summarized my process below in case you see anywhere where I went wrong:
1. Built an asset group for assets V-3340 A through D and mapped the native Pi tags to V-3340 A - D. I added the assets first, then the columns. The columns were named "flow" and "dP"
2. Created a new worksheet for V-3340A and completed my analysis using the "flow" and "dP" tags to find the final output value of "resistance". I had some intermediate calculations of "dP - clean" and "flow - clean"
3. Copy and pasted the V-3340A worksheet and used the asset swap function to switch in V-3340 B - D values, respectively for each new worksheet. The output value of "resistance" made sense for each respective V-3340 asset.
4. Created a new worksheet to compare the V-3340A - D resistance values on a single trend.
5. Added columns for the calculated values of "dP - clean", "flow - clean", and "resistance" to my asset group. I utilized the "existing seeq item" option and picked the option that was not asset specific for the "dP - clean", "flow - clean", and "resistance" calculations .
6. Next, I plotted the "dP - clean", "flow - clean", and "resistance" values for each different asset on a single trend. The "dP - clean" and "flow - clean" values match the values on my individual worksheet, but the "resistance" value only matches for V-3340A. It does not match the individual worksheet values for V-3340B - D.
7. Since "dP - clean" and "flow - clean" values were working correctly in my asset group, I decided to try and manually or "Build formula from scratch" to complete the "resistance" calculation within the asset group. This yielded the same bad result for V-3340 B - D. I've shown the screenshots from both the resistance calc that I built in the V-3340A worksheet that I would referenced when I used the "Seeq calculation" as well as the manual one in the asset group.
Hopefully, that's clear. It's a bit of a head scratcher why my intermediate calcs seem to be working properly in the asset group, but not the resistance value...