This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When you say you want to SUM, do you mean you have an actual numeric field in your data or do you want to count the number of "P"s?
Either way you can accomplish this with a summary tool. First group by the new formula you made there, and if you want to sum on a numeric field then do that after the group by. If you want a count of each "P" and "L" then add a count of your formula.
I have a slightly different suggestion than @EvansM . Once you've created the new P/L variable, you could SUMMARIZE and Group by the P/L variable and then SUM the other amount field. This gives you the sum of P/L.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Thanks @mmenth for quick respond. What I want is if two rows of the data has "P" in it add them together and give the sum of it. And if two rows data has "L'' in it add them together and give me the sum of it.