# Scale a number in reporting

**URL:** <https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645>\
**Category:** Ignition\
**Created:** [September 26, 2023, 1:38pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645 "2023-09-26T13:38:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michele\_Infante](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@Michele\_Infante](https://forum.inductiveautomation.com/u/Michele_Infante)\
**Post date:** [September 26, 2023, 1:38pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/1 "2023-09-26T13:38:53Z")

</div>

Hello,  
i have a problem.  
In reporting i query the avarage power data of an electrical system stored from a tag in watt i want scale from watt to kilowatt. How can i do this?  
Thanks.

---

<div class="post-metadata">

**Author:** ![Mason\_Stevens](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@Mason\_Stevens](https://forum.inductiveautomation.com/u/Mason_Stevens)\
**Post date:** [September 26, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/2 "2023-09-26T16:21:42Z")

</div>

Simplest way I know would be to create a new expression tag to calculate and hold the KW value, (i.e.: `{[default]Watt/Value/Tag} / 1000)`, add historization, and query the new expression tag for the report instead.

Is the report displaying just the current value of the tag, or a list of historical values from the same tag? for example, average power reported once, or a value for every hour from the last month, etc.

---

<div class="post-metadata">

**Author:** ![Michele\_Infante](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@Michele\_Infante](https://forum.inductiveautomation.com/u/Michele_Infante)\
**Post date:** [September 27, 2023, 7:48am UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/3 "2023-09-27T07:48:49Z")

</div>

Yeah i know this method but my data is stored and for report i have avarage and other calculation like Pmax Pmin so i can't use a "friend" tag

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [September 27, 2023, 12:29pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/4 "2023-09-27T12:29:40Z")

</div>

If you only need to _ **display** _ the watts in kilowatts just divide it by 1000 on the report.

 ![watts](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/d/9d8f441d16d5b76d6c03fd985ca3fcd8747e2080.png)

---

<div class="post-metadata">

**Author:** ![Mason\_Stevens](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@Mason\_Stevens](https://forum.inductiveautomation.com/u/Mason_Stevens)\
**Post date:** [September 27, 2023, 12:39pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/5 "2023-09-27T12:39:51Z")

</div>

Yeah, if its older historized data then it'll have to be more involved.

If the report is to be generated infrequently, it may be easiest to export your data to Excel, perform the calculations and pull Avg/Max/Min values, and then import back to Ignition as a dataset. That could get very annoying if this is meant to be a daily or even weekly report, though, and is more of a workaround than a solution.

Does the original tag itself have to be in Watts, or could you maybe alter the engineering units?

---

<div class="post-metadata">

**Author:** ![Michele\_Infante](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@Michele\_Infante](https://forum.inductiveautomation.com/u/Michele_Infante)\
**Post date:** [September 27, 2023, 1:29pm UTC](https://forum.inductiveautomation.com/t/scale-a-number-in-reporting/79645/6 "2023-09-27T13:29:37Z")

</div>

Ty i didn't realize i can make calculation inside the at symbol.  
Have a greet day!