Forum Discussion

prekapRev's avatar
prekapRev
Frequent Visitor
6 years ago
Solved

Counts based on multiple dates in a table

I have a table with multiple date fields (Order Date, Ship Date, Delivery Date). I need to report on counts of sales, shipment and delivery for each month where either sale, shipment or delivery was ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    6 years ago

    Hi prekapRev  -

     

    Force your relationships between Cal_Date and Sales to be 1-to-many (Cal_Date on the 1 side) and it should work for you.

     

     

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
6 years ago

Hi prekapRev  -

 

Force your relationships between Cal_Date and Sales to be 1-to-many (Cal_Date on the 1 side) and it should work for you.

 

 

 

Hope this helps

David

  • prekapRev's avatar
    prekapRev
    Frequent Visitor
    6 years ago

    Changing cardinality fixed the problem. Thanks! I wonder though that why should that be the problem ğŸ¤”