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
Solved! Go to Solution.
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.
Thanks Patrick