Peek funtion

[#1]

Hi all

I have the following data set

Count

0--1

0--2

0--2

I need to only display a 0--2 counts in a straight table when it appears after a 0--1 count

I have the following calculation in the script but have been unsuccessful

If(Match([Count],'0--2') ,'0--2',

Peek([6. Pitch Count])='0--1')as [0--2Count]

Regards

[tresesco · Accepted solution]

Try like:

If([6. Pitch Count]='0--2' and Peek([6. Pitch Count])='0--1', 1,0) as [0--2Count]

Then in the UI use expression:  =Count({<[0--2Count]={1}>} [0--2Count])

Edit: Corrected a bracket