Is it possible to SUM a column over a Unioned Set of Rows in a single Function or would it need to be split across several functions/cells?
In looking at the Documentation it appears that NP("Union") is only relevant if contained within an NL("Rows") but thought I'd try to confirm here.
Thanks,
Sam
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Sam,
Theoretically, it is possible to Sum the results of an NP(Union). However, this is rarely actually an advisable thing to do. If you think about what an NP(Union) does, it combines 2 sets of values and eliminates duplicates. If the values in question are numeric values like amounts and there is a value $34.50 that appears in each set, then the duplicate would be eliminated and you would only be summing that value once. This is rarely the desired behavior. I think in most scenarios, what you want is to execute multiple NL(Sum) functions and add them together. I can't say for certain without knowing exactly what you are trying to do of course, but hope this helps.
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes!
That's what I figured. Is there a Filter Parameter that's available for UNION that instructs it to include ALL and not remove duplicates?
Thanks,
Sam -
Jet Reports Historic Posts Hi Sam,
Nope, I'm afraid there is not. Once again, I think the best choice is probably to use multiple NL(Sum) functions. You can still add them together in the same cell in Excel, but NP(Union) probably isn't what you want in this case.
Regards,
Hughes
Please sign in to leave a comment.