I have a crosstab (
if( data["Unit_DecimalDigits"] == 0 ){this.getStyle().numberFormat = "###,##0";}
else if( data["Unit_DecimalDigits"] == 1 ){this.getStyle().numberFormat = "###,##0.0";}
else {this.getStyle().numberFormat = "###,##0.00";}
if (data["Unit_Name"]=='%') {this.getStyle().numberFormat="#0.0 %" ;}
if(data["Comparative_Name"]=='Actual')
{if(measure["Color_Range"]=='1'){this.getStyle().backgroundColor='Red';}
else if(measure["Color_Range"]=='2'){this.getStyle().backgroundColor='Red';}
else if(measure["Color_Range"]=='3'){this.getStyle().backgroundColor='Yellow';}}
The first two blocks of code work fine, the last one doesn't seem to find anything at data["Comparative_Name"]
, hence it doesn't apply the color settings in the second part of the instruction.
Can someone tell me how to properly reference the "Comparative_name" field in my crosstab?
Help is highly appreciated
walter.haazen@promaco-consulting.com
