Forum Discussion
Matrix Table Rollup
I have a matrix table that is counting objects. There are phases to categorize the count (Phase 1 / 2 / or unphased). All of the counts should be rollup into "DATE_INSERTED". Why are there multiples of the same dates? Shouldn't the counts just roll up into 1 date? See screenshot below for reference.
Ex: Jan 7 / Jan 5 / Jan 4 > Shouldn't these dates be rollup individually and not broken into duplicates?
How can I fix this?
Anonymous , One of the doubts I have is that date has a timestamp.
So change datatype to datetime and take format with time and check.
If it has time, Then create a date column like
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))and use that
1 Reply
Anonymous , One of the doubts I have is that date has a timestamp.
So change datatype to datetime and take format with time and check.
If it has time, Then create a date column like
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))and use that