5 Replies Latest reply: Jun 6, 2017 2:26 AM by Agrim Sharma RSS

    Correct formula

    Agrim Sharma

      can anyone please correct this formula?

       

      =IF(sum({$<[Type of Assignment]={'Allocated'}>}Value7) >[REF BUILD]  , 'OverAllocated',

      IF(sum({$<[Type of Assignment]={'Allocated'}>}Value7) = [REF BUILD]  ,  'CompleteAllocated',

      if(sum({$<[Type of Assignment]={'Allocated'}>}Value7) < [REF BUILD] ,'UnderAllocated' )))