Forum Discussion
Can you post the full formula and copy it here? The way you have it copied looks like it's a syntax error with using " versus '. I would expect something more like this where the entire string is wrapped in " and then the style is wrapped in '
If(
[Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),
"<div style='color:red'>Indirect Expenses Override Amount is greater than 10 percent of the Subtotal Applicable Items amount</div>")
------------------------------
Chayce Duncan
------------------------------
- AmyGosz12 years agoQrew Trainee
HI Chayce....I made the adjustments you indicated and all the yellow highlighting went away, but now the statement showing on the form starts at includes the div tags <div.....and is not in red. Here is my formula:
If(
[Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),
"<div style='color:red'>Indirect Expenses Override Amount is greater than 10% of the Subtotal Applicable Items amount</div>")
------------------------------
Amy Gosz
------------------------------- ChayceDuncan2 years agoQrew Captain
What type of field do you have it set as? Can you confirm it's a formula-rich text?
Is there other content in the formula besides this?
------------------------------
Chayce Duncan
------------------------------- AmyGosz12 years agoQrew Trainee
It is a formula text (not rich text) and there is no other text in the formula box.
------------------------------
Amy Gosz
------------------------------