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

Help on Set analysis

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

14 Replies
apegahfar
Contributor III
Contributor III
Author

here you are

apegahfar
Contributor III
Contributor III
Author

here you are

tresesco
MVP
MVP

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
apegahfar
Contributor III
Contributor III
Author

Dear Tresesco

it works correctly

thanks a lot