Difference between Num() and Money() functions

[#1]

All,

To my surprise I couldn't find any valid reasons why QV has two functions Num and Money for formatting the numbers, as I was able to do everything Money can do with Num.

Please can any body provide me any valid differences thinking the functions usage not the options in "Number" tab.

Regards

Kumar

[sunny_talwar]

I guess there are many other functions, such as Date and TimeStamp which can be used interchangeably, but from what I understand you can set different formats for Num and Money in the script and then if in your dashboard you have to use Money, you can just do Money(FieldName). Whereas, from what I understand you are supplying the second parameter within Num to get the same result as Money, right? Num(FieldName, '$#,##0.00')

[swuehl]

Guess Money() is taking different default parameters for format code than Num() function, as defined in the script variables.

Also the automatic field tagging might be influenced by the function you are using.

[#4]

Hi Stefan thanks for your reply, can you elaborate on "Automatic field tagging"