Very informative article! I was able to pull in my first order date without an LOD expression, instead using a table calc.
My next issue is pulling the sales before the first order date and after the first order
ATTR([Secondary data source].[Date]) < [First Order] Then
SUM([Secondary data source].[Net Quantity]) END
The formula then results in Null values (same thing happens when trying to look at sales after as well).
1 of 1 people found this helpful
Is your First Order a Date value or Something else. Date comparisons generally crash if u dont use same formats like year, month., MDY, week etc...You may try doing Max of one date to fix a value for comparison.
Oh I think I see what you mean. I calculated First Order using: total(min([Date])) which is aggregated, and I am comparing it to an actual date not a value.
I'm guessing that the easiest thing to do would be to address this in the First Order formula I use as opposed to trying to treat the sales date as a value.
If it worked for you, can you mark my reply as CORRECT to close thread.
Thank you for your timely help!