Forum Discussion
Syndicate_Admin
Administrator
AdministratorGrouping by field text
Hello Can you add the minutes of the same code? In the table I have Codes column (text field) and Minutes column (also text field) Minutes = FORMAT(DATEDIFF('mCRM times'[fecha_inicial],'mCRM ti...
Syndicate_AdminAdministrator
AdministratorHello
I'm testing the measure and it seems to work in part, if you look at the capture, in the second table where there is interlocutor and minutes, only adding the last rows already add more than 3h but in the table on the left, only adds 1h and 3m
The formula for Minutes in the second table is
Minutes = FORMAT(DATEDIFF('mCRM times'[fecha_inicial],'mCRM times'[fecha_final],MINUTE) /60/24,"hh:mm")
Do you know what may be happening?
serpiva64
Solution Sage
Solution SageMaybe the sum of 1361 is more then 1 day.