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.
+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
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.”
This GI also have same issue .
This is my GI Report . Can you please have a look ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
