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   60 views   Subscribe  


Hi,

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



Corporate Headquarters

7900 Westpark Drive, A200
McLean, Virginia 22102 USA
1-888-564-4965
Email US Sales Team


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