Peek funtion

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have the following data set

Count

0--1

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

Re: Peek funtion

tresB — Tue, 01 Nov 2016 11:26:36 GMT

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