Currency list with P.O.A (Price On Application)

rodsimm

Hi Programmers,

I have a list of items with prices.
In the price column I would like to be able to add P.O.A (Price On Application) for certain items in the list.
This is possible on the back-end.
However, the column does not sort correctly with 'P.O.A' in the list. The list is sorted as string instead as currency.

Is there a way I can include a string in the list such as 'P.O.A' and order the list as currency, sending the 'P.O.A' to the top of the list?

I hope someone can help solve this problem.

Many thanks,

Example Original:
€240.00,
€100.00,
€12.00,
€130.00,
€25.00,

Example Sorted correctly:
€12.00,
€25.00,
€100.00,
€130.00,
€240.00,

Example Unsorted with P.O.A:
€240.00,
€100.00,
€12.00,
P.O.A,
€130.00,
€25.00,

Example Incorrectly Sorted with P.O.A:
€100.00,
€12.00,
€130.00,
P.O.A,
€25.00,
€240.00,

Example Desired result:
P.O.A,
€12.00,
€25.00,
€100.00,
€130.00,
€240.00,