on 11-22-2017 5:01 PM
use this in the total row.
First i am converting number to string data type to exract hour and mintues in seprate.After that i have converted mintues to hour and added.
=Sum(ToNumber(Substr(FormatNumber([TIME];"0.00");1;Pos(FormatNumber([TIME];"0.00");".")-1))+ToNumber(Right(FormatNumber([TIME];"0.00");2);"00")/60)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
follow these steps.
Var1=Sum(ToNumber(Substr(FormatNumber([TIME];"0.00");1;Pos(FormatNumber([TIME];"0.00");".")-1))+ToNumber(Right(FormatNumber([TIME];"0.00");2);"00")/60)
Final=ToNumber(Substr(FormatNumber([Var1];"0.00");1;Pos(FormatNumber([Var1];"0.00");".")-1))+ToNumber(Right(FormatNumber([Var1];"0.00");2);"00")/10000*60
Drag this in the total row.
Based on the screenshot total of all entries is 6.2.How are you expecting it should be 7?
time column is based on variable or direct object? in case of variable then use foreach () in sum row and add dimensions which needs to be there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.