COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: asmfloyd on 16 Apr 2020 10:40:11 AM

Title: Aligning unit places of a column vertically in a list report
Post by: asmfloyd on 16 Apr 2020 10:40:11 AM
Hi,
  I have a list report which has decimal values and having columns A,B,C,D. If my column B,C has  decimal/percentage and * values (for null rows), I want to align vertically so that all the unit place digits come one below other.
  Ex: If I have 10.0 in first row and 3.4 in 2nd row and * in 3rd row, I want the ".4" to come under ".0" and " * "  to come under ".0".

Thanks,
Title: Re: Aligning unit places of a column vertically in a list report
Post by: MFGF on 16 Apr 2020 12:05:18 PM
Quote from: asmfloyd on 16 Apr 2020 10:40:11 AM
Hi,
  I have a list report which has decimal values and having columns A,B,C,D. If my column B,C has  decimal/percentage and * values (for null rows), I want to align vertically so that all the unit place digits come one below other.
  Ex: If I have 10.0 in first row and 3.4 in 2nd row and * in 3rd row, I want the ".4" to come under ".0" and " * "  to come under ".0".

Thanks,

How is the justification set for your columns? Have you tried right justifying?

MF.
Title: Re: Aligning unit places of a column vertically in a list report
Post by: asmfloyd on 16 Apr 2020 12:19:34 PM
Hi MFGF,
  The justification (horizontal alignment) of columns is marked as "Center" which is a part of my requirement. After centering the value only I need to do this set up of unit places coming one below other,

Thanks,
Title: Re: Aligning unit places of a column vertically in a list report
Post by: asmfloyd on 17 Apr 2020 10:42:29 PM
We do not have a direct way for this. To achieve this, we have to keep justification as right aligned and under padding property, keep a right padding of 0.3 or 0.4inch.