format formula not working 1

[cjbrown815]

Hello,
I have summary fields that make a manual crosstab report. I have to add alerts to these. They are string results

The only part of this formula that is working is the last line, everything else is green.




if ({#Mold}> "9" ) then crRed else
if ({#Mold}in "0" to "5") then crGreen else
if ({#Mold}in "TNTC"">150") then crRed else
if ({#Mold}in "NR") then crBlue else
if ({#Mold}in "<1") then crGreen else
if ({#Mold}in "6" to "9") then crYellow


thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

Please explain the setup of the running total, and if any formulas are referenced, show the content of the formulas.

-LB

 

[cjbrown815]

#MOLD

Field to summarize @MOLD
Type of summary maximum
Evaluate for each record
Reset on Group @Quality Code

@Mold
if {SAMPLEPARAM.PA_NAME} = "Mold-Ct" then
{SAMPLEPARAM.SRESULT}

@Quality Code
{SAMPLE.TEXT3}



-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

I don't think you need to use running totals. You could have just inserted a maximum on your formula at the group level. But anyway, can you show us what value {#mold} has in the group footer and tell us what color it is showing for each for a sample that includes the values in your color formula?

-LB

 

[cjbrown815]

Value/color

13/green
7/yellow
3/green
<1/green
220/green
56/black


I have no "NR" or "TNTC" values to validate the formulas performance, sorry


-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

Change your formula to:

if {#Mold} = "TNTC" then crRed else
if {#Mold} = "NR" then crBlue else
if {#Mold} = "<1" then crGreen else
if {#Mold} = ">150" then crRed else
if totext(val({#Mold}),"000") in "000" to "005" then
crGreen else
if totext(val({#Mold}),"000") in "006" to "009" then
crYellow else
if totext(val({#Mold}),"000") > "009" then
crRed else
crNoColor

-LB

 

[cjbrown815]

Thank you for your patience

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931