equivalent to CurrentFieldValue 1

[cjbrown815]

XP/CRXI/SQL2005

Is there an equivalent to CurrentFieldValue?

The "CurrentFieldValue" cannot be used in a formula field only in conditional formatting, so how do I finish this off? Whats the equivalent?

if {SAMPLEPARAM.PA_NAME}="Ric Avg True Protein" then "AVG True Protein" else
if {SAMPLEPARAM.PA_NAME}="AVG Pct Ash sep samples" then "AVG ASH" else
if {SAMPLEPARAM.PA_NAME}="AVG Pct BF Mojo sep samples" then "AVG BF MOJO" else
if {SAMPLEPARAM.PA_NAME}="AVG Tot Solids Mojo multisamp" then "AVG TS MOJO" else CurrentFieldValue

-CJ

 

[Turkbear]

Hi,
Try:

if {SAMPLEPARAM.PA_NAME}="Ric Avg True Protein" then "AVG True Protein" else
if {SAMPLEPARAM.PA_NAME}="AVG Pct Ash sep samples" then "AVG ASH" else
if {SAMPLEPARAM.PA_NAME}="AVG Pct BF Mojo sep samples" then "AVG BF MOJO" else
if {SAMPLEPARAM.PA_NAME}="AVG Tot Solids Mojo multisamp" then "AVG TS MOJO"  
else 
{SAMPLEPARAM.PA_NAME}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cjbrown815]

You got a doubler for this one

-CJ