I am custom formatting my coordinate grid.
Is there a way to change the following formula so that the output comes with a decimal and suffix?
substr(@grid_number, length(@grid_number) -6,5)
The following provides a suffix, but again I need this to be with less digits like above and a decimal:
abs(@grid_number ) || ' °' || CASE WHEN @grid_axis = 'x' THEN IF (@grid_number > 0, 'E' , 'W') ELSE IF (@grid_number > 0, 'N' , 'S') END
Perhaps there is a way to combine the two so that I can achieve a coordinate format like the following: