Text Object, Text equation trouble

[#1]

I am having trouble getting this equation to resolve

=text(‘Expected Cost for Fees Awarded: ‘) & num($(fees_awarded_expected),’$#,##0’)

error msg indicates, ')" expected but I am not seeing a missing ).

Any guidance to this new Qlik user would be greatly appreciated!

[marcus_sommer]

The text() won't be needed:

= ‘Expected Cost for Fees Awarded: ‘ & num($(fees_awarded_expected),’$#,##0’)

and if your variable returned a valid number then it should work.

- Marcus

[Peter_Cammaert]

I guess the error occurs because of something that Marcus already hinted at: whenever $(fees_awarded_exprected) doesn't resolve to a valid expression, the num() function syntax will become invalid.

Make sure that variable fees_awarded_expected does contain a valid value or field name.

Peter

[maxgro]

=text('Expected Cost for Fees Awarded: ') & num($(fees_awarded_expected),'$#,##0')

or

='Expected Cost for Fees Awarded: ' & num($(fees_awarded_expected),'$#,##0')

both works

[#5]

Thanks everyone for the quick replies !   I went back and took a look at the variables I created and, found that I had capitalized the word Fees in the variable.  Total newbie error, however, lesson learned in that I now know that matters.   Thanks so much once again for the quick replies!!

[sasiparupudi1]

please close this thread by marking the correct answer