In Pivot Table , the time is not showing properly . It showing as Integer .
For example below GI based Time sheet report for Equipment / Employee Time . This is showing correctly
but when we make a Pivot table using the same data the time is showing as integer , any option to show it as proper time .
Tried “Format” option on Pivot table but it does not helped.
Best answer by meganfriesen37
If you want to just convert it to decimals (i.e. 4:30 becomes 4.5 and then it’s way easier to do math with) then try this formula: =IsNull(cdbl([PMTimeActivity.TimeSpent]),'0.00')/60 (I’m looking at the PMTimeActivity table, so swap out the appropriate time field into the formula)
+4
Have you tried setting a schema on the field in the GI which the pivot is using?
Also, what formatting are you trying to use on the pivot already?
Tried Schema option but it is not helping . Trying to use HH:mm as format
+4
in GI Result Grid.
+4
You should try using PMTimeActivity.LastModifiedDateTime, this worked for me:
“The data type that is expected for this column mismatches the data type of the following retrieved value: 1491.”
+4
This GI also have same issue .
This is my GI Report . Can you please have a look ?
Hi
+12If you want to just convert it to decimals (i.e. 4:30 becomes 4.5 and then it’s way easier to do math with) then try this formula: =IsNull(cdbl([PMTimeActivity.TimeSpent]),'0.00')/60 (I’m looking at the PMTimeActivity table, so swap out the appropriate time field into the formula)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.