Set analysis help

[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

[pathiqvd]

Hi,

Try This,

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

Regards.

[arvind_patil]

Hi Amirhossein,

Please try below:

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

Thanks,

Arvind Patil

[apegahfar]

Dear lakshmipathi p                   

thank for your reply

unfortunately it didnt work

[apegahfar]

Dear Arvind Patil

thank for your reply

unfortunately it didnt work

regard

[apegahfar · Accepted solution]

I find the correct answer . it works well

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