Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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