Rounding values up

2 Comments

  • 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!

    1
  • Nicole - Community Manager
    Comment actions Permalink

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

    1

Please sign in to leave a comment.

Powered by Zendesk