Which Of The Following Formulas Is The Best Option For SUM’ing A Set Of Values Held In Column A Of Multiple Dynamic Data Source Instances? NOTE: The Possible Values For The Dynamic Property Is In Column B Of A 2nd Data Source.

Certification Answers
Which Of The Following Formulas Is The Best Option For SUM’ing A Set Of Values Held In Column A Of Multiple Dynamic Data Source Instances? NOTE: The Possible Values For The Dynamic Property Is In Column B Of A 2nd Data Source.
  • SUM(MAP(A:A))
  • SUM(B:B)
  • SUM(MAP(B:B))
  • SUM(A:A)
  • SUM(ARRAY(JOIN(MAP(B:B)))
  • JOIN(A:A)