I’m using the LL23 designer to generate a report from XML data.
The data is mostly numerical but can contain “inf”, “-inf” or “n/a”.
I use the following Value expression in the Crosstab to convert these to specific values:
If(Contains(Lower$(TOTResult.Value), "n/a"),
12345,
ToNumber(StrSubst$(TOTResult.Value, "inf", "999999999")))
This works OK, e,g, I get 12345 for “n/a” (tested in an additional cell; Displayed Contents is TOTResult.Value so “n/a” is displayed).
My problem is in the Conditional Formatting Condition.
There it is not possible to use TOTResult.Value and Displayed Contents is also not accessible; furthermore, trying to use Crosstab.Value() there leads to a crash in LL.
Therefore I have to use LL.CurrentValue (which is actually the reason for the specific value 12345).
Unfortunately LL.CurrentValue returns 0 for “n/a” in the Conditional Formatting Condition…
Anybody know a way around this?
Thanks!