1 of 1 people found this helpful
you said that cash brokerage net is calculate - I assume it is also aggregated
if that is the case you can wrap all your [Date] fields in an aggregation function - attr() , Min(), max() whatever makes sense in your analysis
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
2 of 2 people found this helpful
Cash_Brokerage_Net is aggregated one. please use the min or max based on your requirement
IF MIN([Order Date]) <= TODAY()
and MIN(DATEDIFF('year', [Order Date], TODAY())) = 0