Working on my XML/XSL Filemaker project again and am wondering how to implement the format-number function to get currency format from Filemaker Data.

I understand the syntax of the format-number command, just not how to apply it to the field data coming from Filemaker.

This gives me what I want:

as it returns 12,345.67. But that's obviously static text.

Here's the XSL for the field I want to apply the formatting to:

 

So where do I put the format-number?

Thanks for any help!

Mike

Ahm... where IS the actual number?

Well, the following code returns the number in my browserecord.xsl style sheet:

Well, the following code returns the number in my browserecord.xsl style sheet:

�l:text>

It's returning the field RSResults::STotalDisplay.

Just not sure where in the process I format the returned value.

Thanks,

Mike

I don't know how you managed to make your message invisible. Anyway, I told you I am not too familiar with CWP/XSLT, so the code looks a bit cryptic to me. I am guessing that:

should do the job, though I am not sure why

couldn't work just as well

That definitely worked!

Thanks so much for your help.

Mike