How can I 'sum' non numeric fields to pull data through from one module to another?
I am trying to pull non numeric data through from one module to another. I have found that "If your mapping table contains the Source List and maps to a Target List-formatted Line Item or List-formatted Property, then use SUM in your formula." but how can I pull this information through when the data I need is text formatted and not numerical?
I don't want to build a huge re-staging module unless absolutely necessary....
Obviously, you do need to be careful with FIRST and LASTNONBLANK if there are duplicates that you are effectively trying to “sum”, but depending on the use case, these, and the other methods are a very powerful way to achieve a simple solution to the problem.
See here for more details of the different options
Re: How can I 'sum' non numeric fields to pull data through from one module to another?
I would add that TEXTLIST is also an option. It's not applicable for this example.
But as we know TEXTLIST is a very heavy calc and should be avoided if possible (as per Planual 2.02-11). If you do need to use it, be careful and ensure there is no other way to solve the problem, and make sure the target dimensions are appropriate to reduce the target calculation size