1. 

   haigda, Member

   Hi,

   I have a problem where formatting commends seem to appear in a column and I am unable to remove or hide it.

   This appears in a column "]0.00%" when the column I believe is null - this is the column select and it is on the left hand side of a Right Join and part of an overall Union

   (sum(ifnull(vdt_IPOCallData.CallLost,0))/count(vdt_IPOCallData.DialledNo)*100) as '% Calls Lost'

   The formatting applied is -
   select 'dbr.colstyle', '% Calls Lost', mydbr_style('Percentage2Points');

   Any ideas on how to get rid of the "]0.00%" ("" do not appear)

   Cheers,
   David
2. 

   myDBR Team, Key Master

   David,
   what is the style you are applying, e.g. what is the definition of the Percentage2Points style?

   --
   myDBR Team
3. 

   haigda, Member

   It is -

   %.2f%; ; [color: red;]%.2f%

   Cheers,
   David
4. 

   myDBR Team, Key Master

   David,
   remove the extra space in front of the [color:red], i.e make the style:

   %.2f%; ;[color: red;]%.2f%

   --
   myDBR Team
5. 

   haigda, Member

   Excellent all gone - Thank you

   Cheers,
   David

Reply

You must log in to post.