Please help me with this, I am building a water billing system.
I want to Calculate for Residential and Commercial account,
if the customers type of connection is Residential then Amount=Consumption*15
if the customers type of connection is Commercial then Amount=Consumption*30
flow:
(previous reading)-(present reading)=Consumption then we have a tariff in our office w/c determines the amount of the consumption.(I have already a code base on my tariff)
this is the actual image of query