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!
I will try it out, thanks!
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”.