handle fuel tank

Good morning everyone
I am unable to make a model that helps me handle a tank of fuel. I explain better.

This tank supplies our vehicles. When he has run out of fuel, he must be refueled too.

How would you solve this question?

thank you for your time dedicated to this

Solved Solved
0 1 45
1 ACCEPTED SOLUTION

Create an app where each fuel supplied is logged.  Say the tank is 1000L, you add the following records:

+1000L

-56L

-123L

-98

Then do something like SUM(Select(TableName[TotalFuel],TRUE)) to get the live total in the tank (1000-56-123-98 = 723).

Simon, 1minManager.com

View solution in original post

1 REPLY 1

Create an app where each fuel supplied is logged.  Say the tank is 1000L, you add the following records:

+1000L

-56L

-123L

-98

Then do something like SUM(Select(TableName[TotalFuel],TRUE)) to get the live total in the tank (1000-56-123-98 = 723).

Simon, 1minManager.com

Top Labels in this Space