Hi friends,
I am trying to use peek function to get calculation of difference in DFC
Sum(if(match(Week& text(Material) & text([Customer Loc]), %Key)>0,DFC,0)) - Sum(if(peek(match(Week& text(Material) & text([Customer Loc]), %Key)>0),DFC,0))as WeekDFC
Attached a sample file for reference. of Data,
Basically i am trying to calculate calendar days using dFC difference between every week for that particular product and location.
