Blank value

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Blank value

Viewing 4 reply threads
  • Author
    Posts
  • February 27, 2023 at 5:52 PM #49056

    Glen Forister
    Participant

    I can’t find a way (probably not possible) to return a value of “BLANK” instead of a zero.
    Is there a way in this equation?
    (IFNOTEMPTY(Purchased;MONTHS(Purchased;TODAY());0))/12
    Thanks.
    Maybe, use the results of this field, call it into another field and and Script it there with an if statement if it is zero, leave it blank?
    All those zeros are distracting from seeing my data.

    Thanks.

    February 27, 2023 at 6:26 PM #49057

    Daniel Leu
    Participant

    Instead of returning 0, just return nothing (""). Additionally, I moved the divide by 12 calculation to the matching branch. Seems to be working for me.

    IFNOTEMPTY(Purchased;MONTHS(Purchased;TODAY())/12;"")

    February 27, 2023 at 6:45 PM #49058

    Glen Forister
    Participant

    That works nicely. I didn’t think of that “”.

    February 27, 2023 at 9:14 PM #49059

    Daniel Leu
    Participant

    Great that it works for you!

    > I didn’t think of that “”.

    And moving the division. Otherwise you would get a 0 anyway.

    February 28, 2023 at 10:03 AM #49060

    Glen Forister
    Participant

    I didn’t see where the division needed to be at all, but it does make sense. That would have given me a headache. I had to go for MONTHS instead of YEARS to avoid the integer and get a partial part of the year. Worked great.

  • Author
    Posts
Viewing 4 reply threads

You must be logged in to reply to this topic.