10 Replies Latest reply: Sep 25, 2014 7:06 AM by Andrei Kaliahin RSS

    skipping the entire row if there is null

      Client Service ID

      Client Service Name

      NSR

      No of hours

      DTGL503010000

      Corporate Finance Advisory

      0

      591.5

      DTGL503040000

      M and A Transaction Services

      3335613

      2139.1

      DTGL503050000

      Valuation Services

      114000

      74

       

       

      if ([SERVICE_LINE_CY_YTD_TOTAL_HOURS_ALL_ENTITY_AMOUNT]<0 and [SERVICE_LINE_CY_YTD_NSR_ALL_ENTITY_AMOUNT]> 0) then (null)

      else if ([SERVICE_LINE_CY_YTD_TOTAL_HOURS_ALL_ENTITY_AMOUNT]>0 and [SERVICE_LINE_CY_YTD_NSR_ALL_ENTITY_AMOUNT]< 0) then (null)

      else ([SERVICE_LINE_CY_YTD_NSR_ALL_ENTITY_AMOUNT]/[SERVICE_LINE_CY_YTD_TOTAL_HOURS_ALL_ENTITY_AMOUNT])

       

      I have a situation that should calculate the sum(NSR)/sum(no of hours) but It should calculate the sum(NSR) and sum(no of hours)

      when the number is neither positive nor negative

       

      If it is either positive or negative or zero then it should skip the entire row and calculate

       

      Ps: if needed any information i can give bit more information but not an sample application