Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
=Count({<Period,PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)
May be this:
=Count({<PeriodCode={"$(=Num(FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))))-1)"}>}Period)
Along with this, could you please check what below function is returning? This will help you to identify the root cause.
=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))
Hope this will be helpful.
Regards!
Rahul Pawar
Let's assume
FieldIndex('Period', GetFieldSelections(Period)) -- 4 // Assuming, you are selecting 4th record from Period Table
FieldValue('PeriodCode', 4) -- ABC // May be 4th place of PeriodCode is ABC
Then how you need ABC - 1 ???
If you are looking for the earlier indexed value count of the field, you may try with a bracket correction like:
=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))-1))}>}Period)
Dear Rahul Pawar
thank for your reply
unforetunately it didnt wotk
i checked (=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))))
it works
regard
Dear Anil Babu Samineni
thank for your reply
the Format of PeriodCode is number. as a resault FieldValue('PeriodCode', 4) return number not string
i checked (FieldIndex('Period', GetFieldSelections(Period))-1 )
it works correctly
regard
Dear Tresesco
thanks for your reply
i try that
it didnt work unfortunately
regard
Will you able to provide work file to test?
Can you provide sample apps???
Regards,
Can you add the expression to your table as a new column with no label.
Then if you hover over the column header you can see how the variables in your set expression are being evaluated, which may help identify the problem.