9 Replies Latest reply on Jul 5, 2016 3:50 AM by Ashish Chaudhari

    Calculated field to indicate if equipment is in use or not


      Hi all,

      I'm just not getting this, so please help.  The exam question is I need to be able to count the number of tanks in use at any one time.  I have a series of steps of a process and each step has an associated start and end time (the data is a little dodgy but forget that for now), each step is also associated with a particular tank.  What I'm trying to do, is use a calculated field to see if the "current time" is between the start and end time, then the flag is true, else the flag is false.  My thinking is that if I sum up the number of true fiags at any one stage, then I can see the number of tanks in use.  I'd like to plot how many tanks are in use on a continuous line chart.


      Thanks in advance,

      see attached file.