Skip to main content
Question

Calculating Percent difference

  • March 24, 2022
  • 0 replies
  • 48 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
  • SSNJeffP
  • Registered
  • March 24, 2022
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
------------------------------
Terms & ConditionsAccessibility statement