Showing the difference between 2 values within the same field

I have 2 fields I’m trying to compare. A “Cost” field of $ values, and a “Range” field that includes 3 options, Low, Medium, High. What I would like to do is to plot the difference between the “Cost” of the High and Low “Range” as a line but I’m not sure how to go about doing this or if this is possible.


Hi @brogers04 -

assuming the data looks like this:

you can use a LAC-A like this to calculate the range between High and Low for each item:


Here is more info on LAAs:

If it helps, please mark it as a solution. Thanks for posting!

1 Like

I will try it out, thanks!

1 Like

Hi @brogers04

We hope the response from @gillepa helped you. Let us know if this is resolved. And if it is, please help the community by marking the answer as a “Solution”.

Many thanks.