Peek Function

[bushpalaamarnat]

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.