Spotfire Ideas Portal
In cross table a column that is formatted as h:m:s gives the correct grand total. However the same column if formatted as hh:mm:ss, the behavior changes and Spotfire resets the hours to 0 after every 24 hours and gives a different grand total. Example >> 35:16:58 when formatted as hh:mm:ss shows a value of >>11:16:58.
Please refer to case # 01553884
The idea of formatting is to change the visual appearance of the data. Formatting should not change the value of the data. Please try to implement the same asap. Thanks.