Values not grouping by field in table

[MalcolmCICWF]

I have not had this issue amongst other reporting, and I'm not sure if it has to do with the date field having a time stamp before I am reformatting it, but let me know what you think. The data is pretty straight forward, but wont roll up under the same Client or Date field...

[vishsaggi · Accepted solution]

Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field.

[MalcolmCICWF]

Ok that's the only think I could think of causing the problem. Good suggestions, let me try that and I'll

report back!

[MalcolmCICWF]

That did work, thanks for the suggestion