Skip to main content
Question

Calculating Percent difference

  • Mar 24, 2022 9:50 PM UTC
  • 0 replies
  • 55 views

Forum|alt.badge.img+6
I have Utility usage (electricity, nat gas, water) for 2021 and 2022.  What I would like to do is compare the two years and do a percent difference for each plant.  

Any ideas how to do that?  The calculation is easy but how can I get Jan 2021 electricity for a plant on the record for Jan 2022? 


------------------------------
Sarah Burres
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Qrew Colonel
  • Mar 24, 2022 11:08 PM UTC
How are you saving these values year to year?  Do you have discrete fields for 2021 and 2022?   This might be a good use for a formula query.

------------------------------
Jeff Peterson
------------------------------