you are  correct, I  did forget that.  you  see I am not a developer as  I  suspect  many on this board are. most of my projects  are  proof  of  concept,...

ok sorry, had an unexpected family matter come up over the weekend, so I am later getting data loaded..  attached is an excel workbook, with two worksheets
answerset = what I...

thanks that was so obvious, that I missed the "tree" for the forest.  I just need to sum that section same as I was doing.  when I replaced the simple...

agreed let me put together the necessary table data and post.  will do that today, or maybe over the weekend thanks

thanks  for  the reply. but  that  is actually  the  issue  I am trying to  solve.  if I  use alternate currency as a group function member I get two rows.  in...

ok so I got this to work just fine, and it returns the data set I need.  Except for the last column  Sum

April 11, 2018 at 1:18 pm

#1986458

sorry  was not clear, CAD was just my example there are 1,000's of rows with many different local currencies.  And we get new currencies usually quarterly.  thanks
CAD
MXN
TWD

thanks I will look at cross apply
in order to get something to Mexico, I just did this
I know it is just brute force coding, but I had to...

yes I have 5 interfaces that come in from 5 different companies. This example is from Mexico the prior was from Netherlands.  I wanted to use Stuff, and of course...

Joe thanks for the answer.  I will take some time to understand this option

in the short term I have researched Stuff and think I have the basics.  I...

Yes I have not researched "stuff" yet, but just by looking at your code I figured it was right to left.  I am looking forward to learning "stuff"