0

Sum the checked items in Dynamic Multiple Choice

Need to sum the checked items in Dynamic Multiple Choice is these example 1400 €

There are any way to sum this ?

I try it but no way sum(chosen('Sub Components'))sum(chosen('Sub Components').'Budget')

4 replies

null
    • Fred
    • 11 days ago
    • Reported - view

    try a for loop and record() command. 

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 days ago
      • Reported - view

       Hi Fred

      The Formula I need is on the X Components. All my price are on X Components

      • Fred
      • 11 days ago
      • Reported - view

       Remember that dynamic choice fields give you the recId so you will need to also use the numbers() command in the for loop so you can then use the record() command. It would look something like:

      sum(for componentRec in numbers(dynamicchoice) do
          record(tablename,componentRec).Price
      end)
      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 days ago
      • Reported - view

       Thanks Fred work right.👍

Content aside

  • Status Answered
  • 11 days agoLast active
  • 4Replies
  • 31Views
  • 2 Following