Column Rule for Unknown Fields in Table Tool

[macjg]

Hi all,

I've been hitting a dead end here with a formatting issue that seems like it should be fairly simple.

I'm trying to apply certain formatting based on the values in a table generated from cross tab with strings in first two fields and numeric values in the rest (e.g. red for negative numbers). However it needs to apply to *unknown fields which I expect to pop in to my data record each time I run the workflow.

I keep hitting type mismatch errors using ToNumber([_CurrentField_])<0 for the column rule in dynamic/unknown field.

Any help would be much appreciated!
Thanks in advance
macjg

[patrick_mcauliffe · Accepted solution]

@macjg 

I'm not sure I understand the use case, but I certainly understand the error.

You need to send in all of the records as strings if you want to make it run correctly.

For that, I used a Multi-Field tool to update Nulls with zeros and converted them all to strings.  

See the attached and let me know if it works/makes sense.

[macjg]

Thanks Patrick