Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apegahfar
Contributor III
Contributor III

Set analysis help

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

1 Solution

Accepted Solutions
apegahfar
Contributor III
Contributor III
Author

I find the correct answer . it works well

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

View solution in original post

5 Replies
pathiqvd
Creator III
Creator III

Hi,

Try This,

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


Regards.

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Amirhossein,

Please try below:


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


Thanks,

Arvind Patil

apegahfar
Contributor III
Contributor III
Author

Dear lakshmipathi p                   

thank for your reply

unfortunately it didnt work

apegahfar
Contributor III
Contributor III
Author

Dear Arvind Patil

thank for your reply

unfortunately it didnt work

regard

apegahfar
Contributor III
Contributor III
Author

I find the correct answer . it works well

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