Concatenating String & Number in formula

[digilantis]

I seem to having a problem getting rid of my decimal point & 00 with this formula
ToText("Total Customers Not Satisfied&quot+" " + CStr(Sum({@TotalRecords},{results.accountno}))

If I remove the CStr it tells me a string is required here

The output is Total Customers Not Satisfied 99.00, i need to ditch the .00

any suggestions?

thanks

 

[jjames]

Try this...

"Total Customers Not Satisfied &quot + ToText(Sum ({@TotalRecords},{results.accountno}),0)