Total is showing Null in Table

[bhavvibudagam]

Hi Experts,

Can any one Please help me on this.

In the below table Under Duration Measure I am not able to get the Total. Its showing Null.

In the Measure if I have taken Sum(Duration) the entire Column is showing 0 so in the Measure taken direct field as Duration then getting the Values but coming to Total getting null.

Please help me to resolve the issue. Please find the attached app also.

Thanks in advance.

[devarasu07]

Hi,

Try to apply total as "Sum" instead of expression auto total

can you share the excel file? is that duration text format then convert into number and try again.

[Chanty4u]

try this    interval(sum(duration))Change Email in community

[Chanty4u]

or this

interval(Sum(Duration),'h:mm')

[sunny_talwar · Accepted solution]

Try this

Interval(Sum(Interval#(Duration, 'h:mm')), 'h:mm')