Dear Team,

I am encountering an issue with applying parentheses for cell styles. I have followed the provided instruction:

**An extension to printf-format (%0.0N for zero decimals, %0.2N for two decimals), myDBR allows formatting negative numbers as positive allowing accountant style formatting (optionally with parentheses). The following format would show the negative numbers as positive, in red wrapped in parentheses. Sorting will still be done with actual values.
%0.1f;-;[color:red](%0.1N);
**

However, this solution does not seem to be working for me. Could you please assist me with this matter?

SELECT 'dbr.colstyle', 'ty', '%.0f; ;%.0f';

select 'dbr.cellstyle', 'ty', 'd_style';

CASE

WHEN @currencyType = 'USD' THEN

CASE

WHEN @priceFormat = 'Thousand' THEN sum(b.recent) / 1000 / @exchange_rate

WHEN @priceFormat = 'Million' THEN sum(b.recent) / 1000000 / @exchange_rate

WHEN @priceFormat = 'Billion' THEN sum(b.recent) / 1000000000 / @exchange_rate

ELSE sum(b.recent) / @exchange_rate

END

ELSE

CASE

WHEN @priceFormat = 'Thousand' THEN sum(b.recent) / 1000

WHEN @priceFormat = 'Million' THEN sum(b.recent) / 1000000

WHEN @priceFormat = 'Billion' THEN sum(b.recent) / 1000000000

ELSE sum(b.recent)

END

END AS 'Actual[ty]',

CASE

WHEN sum(b.recent) < 0 THEN '%0.1f;-;[color:red](%0.1N);'

ELSE 'color:blue;'

END AS 'd_style'

Thank you!