Help using expressions in report builder for MassHunter Qual 10

UPDATE:

I think I've figured out how to refer to the numbers I need but it still isn't working, possibly because the number from PCDL is beingpulled in as text instead of a number. Any expert users who could advise on how to make the below expression work?

"FAIL" if BoundItems["ISTD Compound"].Area < BoundItems["ISTD Compound"].DB_Notes else "PASS"

Hi,

try this kind of format for the expression, see below.

Hope this helps.

BR

pwd

Thanks howard_sanford, converting the entry from PCDL to an integer worked. 

Steve

Hello @strob,

See this discussion on how to convert text to float in Report Builder.

You may also want to throw in some checks for Null entries, depending on how rugged you want your report to be. There is an example of this in the code pwd posted (the .IsFinalConcentrationNull() method) and I also discuss it here.