I have some data in a table, lets say in Name, Country, Balance 1, Balance 2, Balance 3, and Balance 4. Balance 3 = Balance 1 + Balance 2, and I need to take the sum of the numbers of Balance 3 that are > 0, and use it to divide Balance 4. The division part isnt the problem, but trying to aggregate the values in Balance 3 where they are > 0 is where I am having issues. I can't just sum the column, because there are negative numbers there and I cannot use those. Any ideas? Still new to Set Analysis... if that is even what I would use...
