Average value display using Expression Tag

Ignition
1

I have a summary dashboard. It has to display the average value of individual plant sites.
I have assigned expression tag with average. However it shows as null value if one of the plant site is down. How to get the average value by only considering the plants which is up.
This is the view which shows null value
image
I have assigned expression tag to the label as shown below

image
image982×743 55.8 KB

Here is the expression tag assigned
image
image1103×802 59.9 KB

the expression in the tag is as follows
{[.]../UTTARKHAND/UTT-1/DASHBOARD/PR/PR}+{[.]../UTTARKHAND/UTT-2/DASHBOARD/PR/PR}+{[.]../MP_SITE/SEMLI/DASHBOARD/SUMMARY/SUMMARY/PR_Today}+{[.]../SECIII/DASHBOARD/SUMMARY/SUMMARY/PR_Today}+{[.]../BAP_SITE/BAP_AVG_PR})/5

Please help me out with this

2

What's the context of the error? (go into the diagnostics of the expression tag and check what the actual error description is, or mouse over the error text in the binding preview)