How to get the last and previous field depends on the selection

[suzel404]

Hi all,

I have to get the last and previous values of field. I realize it with a AutonumberHAsh128 in script and the Only() function but I don't known how can I achieve it.

Exemple:

I select the Range : 10000 - 20000

I can see in the straight table :

- Range selected - TotalAmount,

- Previous Range - TotalAmount of Previous Range,

- Next Range - TotalAmount of Next Range

Previous Range : 6000 - 7450 / 11,6

Range selected : 10000 - 20000 /  3,9

Next Range : 195000 - 220000 / 12

I can realize it with the Seq field but not with not range field.

Thank for you help.

[swuehl · Accepted solution]

You may need to clear the field you selected in to make your set compatible. See attached.

[suzel404]

Thank you Swuehl for your availability. It is exactly what I need.

Many thank.