# Average value display using Expression Tag

**URL:** <https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292>\
**Category:** Ignition\
**Created:** [January 6, 2023, 4:33am UTC](https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292 "2023-01-06T04:33:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![KEERTHANA\_HEMANTH](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keerthana_hemanth/32/42024_2.png) [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\
**Post date:** [January 6, 2023, 4:33am UTC](https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292/1 "2023-01-06T04:33:34Z")

</div>

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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/6/26e94757f9d746e12a5d1206da21d24deb2c16fc.png)  
I have assigned expression tag to the label as shown below

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/5/355676e9529cb084d01a2c6083c3a32cefdfef52.png)  
Here is the expression tag assigned  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/1/a16ea7bb34d808dea9913ee24a2b2068f62866de.png)

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

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [January 6, 2023, 4:48pm UTC](https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292/2 "2023-01-06T16:48:02Z")

</div>

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)
