Hallo, könnte mir bitte jemand ein funktionierendes Beispiel für eine bedingte Formatierung nennen. Es wurden verschiedene Wege versucht (mit Value "True", =True, (True), =1 usw.). Alle führen zu der Fehlermeldung... vielen Dank im Voraus.
What version of OpenLab EZChrom are you running. You can determine this by going to Help>About.
Is RSDRtDimethyl a variable that you have defined on your report template?
thanks, we are using the version A.04.09 Agilent OpenLAB CDS. And yes, RSDRtDimethyl ist the optional variable Name from the Summary Calculations (RSD from Retention Time).
The RSD (from Summary Calc) Format is a Number with 3 Decimal Places. I can use the variable for an IF function (= IIf (RSDRtDimethyl <1, "pass", "fail"))Only that conditional formatting doesn´t want to work.
an equal sign is missing prior the value of 0.7
It should work
Bitte schreiben Sie ein "gleich" Zeichen vor dem Wert 0.7
Hello Mr. Hbar,
thanks for the answer, but unfortunately I still haven't quite understood it. I tried the following combinations:
and the result is always...
i.e. the syntax is now clear to me, thank you very much. It must be due to the value (RSDRtDimethyl).
Make sure that the field you are setting up conditional formatting on further down on the report template than where the RSDRtDimethyl variable is defined. Reports are generated from the top down and left to right, so variables can only be used further down and/or further right than where they are setup.
Also, try using the expression =Val(RSDRtDimethyl) instead of just =RSDRtDimethyl. Maybe it is not formatted as a number and that is the source of the error.
I marked this post as assumed answered due to its age. Feel free to update us with what you found or post again if this is still an issue.
Retrieving data ...