Summary field Count distinct
I'm this is impossible for Quickbase....but I wanted to ask. I have a Parent Table (customers) and a child table (orders).... I want to see a which customers have placed an order in each month over...
Forum Discussion
This can be done with 12 summary fields.
The first one would be for the count of orders in the previous month
The next would be a copy of that but During the last 2 months and not during the Previous 1 month.
The next would be during the previous 3 months and not during he previous 2 months.
Then you would build your final formula using those 12 fields.
Count(
[# orders month 1]>0,
[# orders month 2]>0,
[# orders month 3]>0,
.
.
[# orders month 12]>0)
The first one would be for the count of orders in the previous month
The next would be a copy of that but During the last 2 months and not during the Previous 1 month.
The next would be during the previous 3 months and not during he previous 2 months.
Then you would build your final formula using those 12 fields.
Count(
[# orders month 1]>0,
[# orders month 2]>0,
[# orders month 3]>0,
.
.
[# orders month 12]>0)
