I will need your help to finalize and fine-tune my formula.
My report is containing lots of data but there is one record for each [EC].[Material].
With below formula I am getting the sum of all materials minimum CRD dates, and not for the material only.
What do I need to change to get the on material level only?
=[Qty] Where ([Dist EC CRD] = Min([Dist EC CRD]) In ([EC].[Material])) In ([EC].[Material])
Thanks in advance