Rounding values up


  • Jeremy Clanton
    Comment actions Permalink

    I got it figured out!

    I made a calculated Metric

     IF ([Leg user type]="End-User") AND (VALUE(Call raw duration (sec))<60)
    THEN 1 ELIF ([Leg user type]="End-User") THEN CEIL(VALUE(Call raw duration (sec))/60) ENDIF


    I guess I still need some practice. Thanks if you took the time to read!

  • Nicole - Community Manager
    Comment actions Permalink

    Thanks for coming back and sharing the solution, Jeremy. Glad to hear you got it working!


Please sign in to leave a comment.

Powered by Zendesk