1 Reply Latest reply on Jun 14, 2014 7:01 PM by TKnTexas

    Another newbie question

    JeremyCarr

      Title

      Another newbie question

      Post

           Hi

           Trying to work out a way of not ending up with too many fields.

           I have a number field that uses the following calculation to compare a value, dependant on a gas appliance type,  with one measured onsite, if the measured value matches or is below the value returned by the calculation formula, the conditional formatting stays green and states "OK" else it goes red and states "NO" (as in safe or unsafe)

           It all works fine but I have five appliance readings to report in each record, seems wasteful to have to have five Case formula in the same number of fields especially if I need to edit values etc. If I used a global field is there a way to refer to Ap1typ or Ap2typ... etc using wildcards i.e. Ap*typ?

           Case(Ap1typ="Boiler";.008;
           Ap1typ="Combination boiler";.008;
           Ap1typ="Range Cooker";.02;
           Ap1typ="flued space heater";.02;
           Ap1typ="Flueless space heater";.01;
           Ap1typ="Hob";"N/A")
            
           Any guidance much appreciated

        • 1. Re: Another newbie question
          TKnTexas

               Well a little more info .. but is there always the five readings at each time?  If there is always the five then a field per type might be appropriate.  If the site of the reading and date is common, then the actual readings could be in a portal of a child-file.