Hide calculated field until all data input

  • Resolved ryansvfx

    (@ryansvfx)


    3 years, 10 months ago

    hi. is it possible to show no result in the calculated field until all data has been inputted into the formula? The formula relies on bits of data being imputted, but at the moment, if i add data to 2 or 3 of the fields in the equation below it starts calculating the result live and it shows in the calculated field box. I want to hide the result until all 4 fields have been populated

    my formula is:

    PREC((fieldname2-1)*fieldname1-(fieldname4-1)*fieldname9, 2)

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @ryansvfx

    You can use conditional operations or conditional statements as part of the equation as follows:

    
IF(AND(fieldname1, fieldname2, fieldname4, fieldname9), PREC((fieldname2-1)*fieldname1-(fieldname4-1)*fieldname9, 2), '')

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Hide calculated field until all data input’ is closed to new replies.