Logi Info Forum Threads    >    Posts

Blnak Values in CrossTab Table

Jon Walters
United Kingdom

08 Oct 2019 04:46 AM
This thread is open for replies.
12.5.152-SP2    .NET app   214 views   Subscribe  


I have a crosstab table that contains 0's buit the 0's are not being displayed, the values are just blank?

Brendan Towers
United Kingdom

09 Oct 2019 07:32 AM

If you used the crosstab wizard then the text shown is a calculated expression which replaces zero with blank. See the Label element's Caption property under the CrosstabTableValueColumns element.

You can change this, e.g. from
   =iif(@ Data.rdCrosstabValCount~=0,"","@ Data.rdCrosstabValue~")
to just
   @ Data.rdCrosstabValue~

You can also change the Label's Format to however you want to display the values , e.g. from #,###.# to $#,##0.00


United States
7900 Westpark Drive
Suite A200
Virginia, 22102
[email protected]

United Kingdom
Scott House
The Concourse
Waterloo Station
London, SE1 7LY
020 3103 0306
[email protected]

20 Harcourt Street
Suite 10
D02 H364
3531 400 7506

© Copyright 2020 Logi Analytics, Inc. All Rights Reserved           |          Contact DevNet          |          Site FAQs          |          Terms of Use          |          LogiAnalytics.com