Answered

Show Total of Contents in Fields in a Row in Total Field at End of Row

(0) Share

Report

Posted on by Phineas

5,049 Super User 2025 Season 1

I need to tally a row of fields into a 'Total' field. I can grab the first in the row and replicate in the 'Total' but my attempt to 'Sum', or add the all together, isn't working. What am I missing?

Categories:

General Questions

All responses (3)

Answers (1)

Verified answer

Phineas 5,049 Super User 2025 Season 1 on at

Like (0)

Report

Re: Show Total of Contents in Fields in a Row in Total Field at End of Row

Got it, (courtesy of a previous conversation with @WarrenBelz)
With(
{
_Time_1:
Value(
First(
Split(
Label10.Text,
":"
)
).Value
) +
Value(
Last(
Split(
Label10.Text,
":"
)
).Value / 60
),
_Time_2:
Value(
First(
Split(
Label10_1.Text,
":"
)
).Value
) +
Value(
Last(
Split(
Label10_1.Text,
":"
)
).Value / 60
)
},
With(
{
_Hours:
Sum(
_Time_1 + _Time_2,
0
)
},
Text(_Hours) &
":" &
Text(
Mod(
(_Time_1 + _Time_2),
_Hours
) * 60,
"00"
)
)
)
Phineas 5,049 Super User 2025 Season 1 on at

Like (0)

Report

Re: Show Total of Contents in Fields in a Row in Total Field at End of Row

Same result of '0', should be '8:00'.
Rajkumar_M 3,693 Super User 2025 Season 1 on at

Like (0)

Report
Re: Show Total of Contents in Fields in a Row in Total Field at End of Row

Hi @Phineas

You need to convert these text values into numbers before summing them. You can use the Value function to convert text to numbers.

Value(Label10.Text) + Value(Label10_1.Text)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.