A
airgrz
I am trying to Subtract the MIN of a group from the MAX of a group!
How do I only use >0 numbers in the group!
Example:
1 $500
2 $300
3 $0 or blank
4 $50
I need $50 - $500 = $450
Not $0 - $500 = $500
Thank you in advance for your help!
How do I only use >0 numbers in the group!
Example:
1 $500
2 $300
3 $0 or blank
4 $50
I need $50 - $500 = $450
Not $0 - $500 = $500
Thank you in advance for your help!