Forum Discussion

Reetz's avatar
Reetz
Helper II
3 years ago

Calculated Table that shows rows with no data

I have a sales table with no rows in the table if the sales don't exist for a particular date. I created a calculated table, but get the same result.    I want the calculated table to insert sales ...
olgad's avatar
olgad
Resident Rockstar
3 years ago

I assume the sales table is not gonna be so small in terms of data pump it with some more data so it has the different products on the same dates. Right now whats causing you a problem most probably is one to one relationship.

  • Reetz's avatar
    Reetz
    Helper II
    3 years ago

    Thank you for your response.    My actual sales table has a lot more data with a lot of accounts buying many different products on different dates.  (Although, my company summarizes those sales dates to be all the first of the month).  In actuality, the relationship between the date table and the sales table is a 1 to many.   I tried to scale down the example to uncomplicate it. 

    I went back and added more accounts, products and sales with more dates and got the same results. 

    What I am looking for is if a specific date has no sales for that account/product, I want to show a row for that missing date/account/product with sales of zero.