Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
=text('Expected Cost for Fees Awarded: ') & num($(fees_awarded_expected),'$#,##0')
or
='Expected Cost for Fees Awarded: ' & num($(fees_awarded_expected),'$#,##0')
both works
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!!
please close this thread by marking the correct answer