Remove dates from duration if they are contained within that duration
Hello I am improving my monthly sales forecast chart - essentially it takes the gross sales from the beginning of the month up to today and divides by how many weekdays have passed so far (giving a...
Thanks for responding so quickly Mark and thanks for your contributions - I don't know how you find the time but your comments on many things have been very helpful to me
I'm not sure how to simplify this and explain clearly but I'll do my best: I have about 30 tables but I believe only 4 will be relevant here: "Sales Orders" , "Sales Order Line Items" , "Purchase Lots", and "Purchase Lot Line Items"
Relationships : Many Sales orders belong to one Sales Order Line Item Each Sales Order has many Sales order line items Many Sales order line items belong to one Purchase Lot Line Item Each Purchase Lot has many Purchase lot line items Many Purchase lot line items belong to one Purchase Lot Each Purchase Lot Line Item has many Sales order line items
Essentially a Purchase Lot is created with many purchase lot line items. A Sales Order is created and part or all of a Purchase Lot Line Item is then added to the sales order making it a Sales Order Line Item.
[Total Sales Order Revenue] is a field in the Sales Order table - type: Currency(summary) which sums the Sales Order Line Item assigned values, in addition it has a numeric formula to remove costs Not sure if this is applicable but here's the relationship for the field:
