Forum Discussion

mimi320's avatar
mimi320
Frequent Visitor
4 years ago

Sum if between two dates and keep blanks

I hope this is simple and clear.   I have the following; Invoice Start Date Invoice End Date Qty Sold I need to calculate the sum of Qty Sold between Invoice Start Date and Invoice End Date, ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • NickolajJessen's avatar
    NickolajJessen
    Solution Sage
    4 years ago

    Allright, after having a look at your report, i'd suggest you instead spend some time looking up how to make a datamodel. Specifically you shoud learn about:
    1. The difference between fact tables and dimension tables
    2. How to create relationships between them.
    Avi Singh is my goto resource for this.

    I know it doesn't answer your immediate question, but this task would be so much easier, if there was a proper datamodel behind it. If you rid yourself of these many-to-many bidirectional relationships, your report will behave more predictably.