Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
5 years ago

Adding Duration Fields

I am trying to add duration fields but if one is blank the total doesn't show.  Any suggestions?

[End Time 1] - [Start Time 1]  =  [Time 1 Total]
[End Time 2] - [Start Time 2]  =  [Time 2 Total]
[End Time 3] - [Start Time 3]  =  [Time 3 Total]

So if [Time 1 Total] is 1 hour and [Time 2 Total] is 30 min and [Time 3 Total] is blank it won't give me a [Total Time] ([Time 1 Total]+[Time 2 Total]+[Time 3 Total])

How do I get a total if one of the [Time Total Fields] is blank (null)

------------------------------
Mark Comish
------------------------------

7 Replies

  • np,
    use the Nz() function which will treat any nulls as zeros.

    The formula for the field [Time 1 Total]  should be

    Nz([End Time 1] - [Start Time 1])

    etc for each of the three fields.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MarkComish's avatar
      MarkComish
      Qrew Assistant Captain
      As usual you are the man!!!  Thank you!

      Another question

      On Grid Edit I am pulling from from a field on another table "Opportunities" (Parent Table).  It shows all opportunities but I only want the ones that are from a certain [Division].  I can't seem to figure out how to limit it.

      Thanks as always

      ------------------------------
      Mark Comish
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion

        Sorry, but I'm not understanding the question. 


        Is this an embedded report o a parent record form?



        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------