Forum Discussion
Anonymous
7 years agoNot applicable
Multiple results in one formula
Hi Everyone,
I created 3 new columns with the following formula's:
Raw_Daytime = IF(RELATED(TimeRegistrationReasons[reason])="Support - Daytime (100%)"; [timeSpent_inSeconds] ; IncidentTimeRegistrations[Time])
Daytime = FORMAT((IncidentTimeRegistrations[Raw_Daytime]/3600)/24; "HH:mm:ss")
Daytime_Total = SUM(IncidentTimeRegistrations[Daytime])
The last rule is a measurement.
Basically i filter the raw_daytime (which is text), convert it to hours and minutes and summarize it all.
I have it working with 3 formula's and 3 columns but i want to have it in 1 column if possible.
Thanks in advance,
1 Reply
- v-chuncz-msft
Community Support