Adding Comma in Duration KPI

Asuod_ — Tue, 17 May 2022 17:42:54 GMT

Hello,

I have been asked to put a comma in a duration KPI, I looked around the forums and google but could find an answer. I assume it has to be a custom formatting but unsure how to do that. On the left is what I currently have and on the right is what I'm being asked to change the KPI too. Thank you in advance.

1500:00:00 (h:mm:ss) -> 1,500:00:00(h:mm:ss)

Re: Adding Comma in Duration KPI

brunobertels — Wed, 18 May 2022 08:15:56 GMT

like this

num(subfield('1500:00:00',':',1), '#,###.','.',',')&right('1500:00:00',6)

regards

topic Re: Adding Comma in Duration KPI in App Development

Adding Comma in Duration KPI

Re: Adding Comma in Duration KPI