Posts

Showing posts with the label brackets

Display Negative numbers in Braces "( )"

Image
One of our forum user Vency asked for formatting the number to be displayed with in Bracket, if it is -Ve number Forum Question Might M14 gave a quick resolution, of adding the condition PI to display the brackets on both sides, by concatenating '(' and ')' on both sides respectively. 0 then Sales else ‘(‘||Sales||’)’ end if> Looks good, But this hard-work is not needed, there is a simple solution i guess, its old one, but still will be handy for Newbie's.