Simple Subtraction

user03398

I am trying to use beast mode to calculate the difference between two of my fields to show the difference in another calculated field.  

 

I have a state with x amount of aggregate available and the state with x amount of aggregate used and I am trying to create a calculated field to shown the difference or remaining aggregate available for the state.

 

Any help would be greatly appreciated

AS

As simple as this maybe:

`available column` - `used column`

That would give you the difference on a row level

 

If you ever want to display these amounts across several states or across other dimensions, then maybe aggregate it up like this first

sum(`available column` ) - sum(`used column`)