# Transform function not calculating on Solar dashboard

**URL:** <https://community.grafana.com/t/transform-function-not-calculating-on-solar-dashboard/65545>\
**Category:** Gauge Panel\
**Tags:** home-assistant, influxdb\
**Created:** [May 11, 2022, 3:59pm UTC](https://community.grafana.com/t/transform-function-not-calculating-on-solar-dashboard/65545 "2022-05-11T15:59:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mitya969](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@mitya969](https://community.grafana.com/u/mitya969)\
**Post date:** [May 11, 2022, 3:59pm UTC](https://community.grafana.com/t/transform-function-not-calculating-on-solar-dashboard/65545/1 "2022-05-11T15:59:07Z")

</div>

HI All,

I’m a noob here and new to Grafana, so please forgive me if this is a really basic question.

Grafana v 7.5.2  
InfluxDB v 4.4.1  
Home Assistant OS 7.6  
Raspberry Pi 3

I’ve setting up a Solar dashboard that has a number of panels that show generation over time, generation now, exported energy, consumed energy, etc… All has gone well and I’ve been able to utilise the data captured in Home Assistant via the MyEnergi integration. I’m stuck however, trying to calculate the cash value offset against grid consumption.

I’ve created two queries and the 3rd is a result of a “Transform” binary operation that adds the result of the two queries. As you can see the transform doesn’t appear to be calculating as expected.  
Here are screenshots for showing the queries  
Grid Import (see output of the queries above and you can see that the calculated total is zero but should be -£0.54)

 ![Screenshot from 2022-05-11 16-57-40](https://us1.discourse-cdn.com/grafana/original/3X/a/f/af123afe3572c99fd0f4014d479f94013040a18b.png)

Solar Generation  
Removed as I’m only able to post 2 images but the query is the same as above but with a different entity.

Total

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/3/c/3c94f9b0338f074380259b418cce083a0c650d28.png)

Any assistance would be appreciated as this is all new to me.

---

<div class="post-metadata">

**Author:** ![usman.ahmad](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/usman.ahmad/32/29706_2.png) [@usman.ahmad](https://community.grafana.com/u/usman.ahmad)\
**Post date:** [July 8, 2022, 7:44am UTC](https://community.grafana.com/t/transform-function-not-calculating-on-solar-dashboard/65545/2 "2022-07-08T07:44:15Z")

</div>

Hi @mitya969 , welcome to the community forums.

Thanks for providing the details.

We had tried to reproduce it but were not able to as it seems to work fine when doing the transformation of the 2 queries (Grid + Solar)

Therefore, can you please follow [these steps](https://cln.sh/PTgRFb) to share your raw unformatted data? That way, the community can try and mock up your problem 👍

> **[show-inspect-data](https://cln.sh/PTgRFb)**
>
> GIF uploaded to CleanShot Cloud