Water cost overage calculation

Hello all, hopefully I’m not double posting but I couldnt seem to find an answer to my below question.

I have just recently setup ai on the edge to monitor my water meter and that is working perfect! I got that added to my energy consumption board and would like to start tracking price. This is where im a little confused on how to do this with how water is billed in my area. So we have a set $48 per 9,000 gal used in a quarter and a $2.10 charge per every 1,000 gal over the 9,000. Is there anyway to input this?

Any help would be greatly appreciated! Thank you all in advance!

I think there is a way to do this using the support for “tarrifs”, search the forum for that term.