I'm having an issue when I use the cross tab tool that I can't figure out. The input data looks like below and I'm using the Cross tab tool to group the data by Day going down and Time going across. So I would expect Day 01 Time 00:00 to be 0 and Day 01 Time 00:15 to be 19.91, however that's not the results after the cross tab tool (see second screenshot). It seems to only be incorrect on Day 1 and the other days are pulling correctly.


I have attached my workflow and input files, can someone please help!