4 Replies Latest reply on Feb 22, 2016 5:41 PM by Jason CHEN

    Help--is a calculated field  problem

    Jason CHEN

            For example  :a  calculated field,name is efficiency and values  is  average efficiency/count(equipment) ; average efficiency  = unit / working hours

                                                                    other is  target,values is 50 number

                                                                     customer

       

                create a calculated field and user if function values is:   if efficiency >= target and customer  ='china' then 1 else o end,

                                                       or   user iif function values is:  iif (efficiency >= target and customer  ='china', 1,0) 

       

       

      both results are getting wrong, how to make it correct?