Help on Set analysis

[apegahfar]

Hi Community,

I am trying to use below function as expression in a straight table

=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

but it doesnt work

however without '-1' it works

please help

regards

[apegahfar]

here you are

[apegahfar]

here you are

[tresesco · Accepted solution]

Try like:

=Count({<Period,PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

[Anil_Babu_Samineni]

May be ignore Selections using Period and i got as 398?

[apegahfar]

Dear Tresesco

it works correctly

thanks a lot