Showing the difference between 2 values within the same field

Question & Answer
1

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.

Thanks!

2

Hi @brogers04 -

assuming the data looks like this:

image
image832×716 24.3 KB

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

image

Here is more info on LAAs:

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

1 Like
3

I will try it out, thanks!

1 Like
4

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.