Formula is not working after row ID [9] in subforms

回答済み

フォローする

Juho-Matti Jaaskelainen

• 2021年05月19日 06:28

Hello Community,

I have issue calculating row values using formulas when row id > [9].

I have six subforms filled by auto-lookup and each auto-lookup result will have exact 12 results representing months of the year. I have another subform where I summarize those rows [1] = Jan, [2] = Feb and so on like this:

sum(${SubForm1/Field1:[1]})+ sum(${SubForm2/Field2:[1]})+ sum(${SubForm3/Field3:[1]})+ sum(${SubForm4/Field4:[1]})+ sum(${SubForm5/Field5:[1]})+ sum(${SubForm6/SubForm6:[1]})

All works fine until [10]. Is [1] to [9] are calculated correctly but after this formula is not working with [10],[11],[12]:

sum(${SubForm1/Field1:[10]})+ sum(${SubForm2/Field2:[10]})+ sum(${SubForm3/Field3:[10})+ sum(${SubForm4/Field4:[10]})+ sum(${SubForm5/Field5:[10]})+ sum(${SubForm6/SubForm6:[10]})

Am I missing something how to reference rows after 9 in the formulas?

Best Regards,

Juho-Matti

 

 

 

0

• 正式なコメント

  

  Varun Agasthya

  • 2021年05月19日 15:20

  Hello Juho-Matti,

  Hope you are doing good. The observed behavior is already identified as a product issue and the fix has been made available in AgilePoint NX 8.0 Software Update 1 release which is scheduled to be released mid of next month. If you have any urgency with this issue, we would request you to raise a support ticket for further discussion.

  Thanks

  コメントアクション パーマリンク

サインインしてコメントを残してください。