on 09-07-2020 10:34 AM
current-webi-table.pngdesired-webi-table.pngHi All,
I have columns called "Incident ID" & "Total Pending Time" where there are duplicate values in Incident ID column.
I need to sum the Total Pending Time of Duplicate Incident ID values.
Attached Screenshots for reference .
Please help me....
Regards,
RK
WebI will automatically sum it (aggregate) if you have both columns only in the table.
Why does your current table have a lot of duplicate rows? Are there other columns in your table with different values in each row?
...
If you want to get the total for each ID, use this formula:
=sum([Total Pending Time]) in ([Incident ID])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.