topic Re: Set analysis help in App Development

Set analysis help

apegahfar — Mon, 07 Aug 2017 14:01:37 GMT

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 — Tue, 08 Aug 2017 09:53:38 GMT

Hi,

Try This,

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

Regards.

arvind_patil — Tue, 08 Aug 2017 09:57:11 GMT

Hi Amirhossein,

Please try below:

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

Thanks,

Arvind Patil

apegahfar — Tue, 08 Aug 2017 10:06:08 GMT

thank for your reply

unfortunately it didnt work

apegahfar — Tue, 08 Aug 2017 10:07:51 GMT

Dear Arvind Patil

thank for your reply

unfortunately it didnt work

regard

apegahfar — Tue, 08 Aug 2017 13:09:45 GMT

I find the correct answer . it works well

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