When I run the following part of code - Which works out a weekly rent from a monthly one
WHEN Loc.[rent-group] = 'F' THEN COALESCE(ARENT.[NET-AMT]*12/52,0) /*To work out weekly rent on monthly run*/
I'm getting the result coming back as "114.230769" as an example.
How do I get it to come back as - "114.23"?