I have formula number field in a report that I need the average displayed in time. Below is the formula I've been working with but cannot get it to run without error.
(FLOOR(FLOOR(Case.IRT_Value__c:AVG) - (MOD(Case.IRT_Value__c:AVG, 1) * 10/6))+ '.'+
((MOD((Case.IRT_Value__c:AVG, 1) * 10/6, 1)) * 6/10))
3 answers
Hi @Aimee Redlinger,
Try this
TEXT(FLOOR(Case.IRT_Value__c:AVG)) & ":" &
TEXT(ROUND((MOD(Case.IRT_Value__c:AVG, 1) * 60), 0))
might helps you,
Thanks
