1 2 Previous Next 19 Replies Latest reply on Jan 17, 2019 10:06 AM by sajad.bhat

    Help with the formula

    Kalyan Raman

      The below is formula is valid, but says 'applies a numeric aggregation to a on-numeric field' IF [cancellation_time] = NULL AND [fill_time] = Null THEN 'order_time' ELSEIF [cancellation_time] != NULL AND [fill_time] != Null THEN '[fill_time] - [order_time]' ELSEIF [cancellation_time] != NULL AND [fill_time] = Null THEN '[cancellation_time] - [order_time]' ELSEIF [cancellation_time] = NULL AND [fill_time] != Null THEN '[fill_time] - [order_time]' ELSE 'NULL' END any help is appreciated.

        1 2 Previous Next