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
    • 3 wk ago
    • Reported - view

    try a for loop and record() command. 

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 wk ago
      • Reported - view

       Hi Fred

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

      z wbs (Restore).ninox
      • Fred
      • 3 wk 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
      • 3 wk ago
      • Reported - view

       Thanks Fred work right.👍

Login to reply

Content aside

  • Status Answered
  • 3 wk agoLast active
  • 4Replies
  • 36Views
  • 2 Following