Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make it return with out decimal point ?

Hi All

I use below expression :-

money(

sum(sales/Rate)

,$#,##0)

it return with 2 decimal point.

May i know how to make it return with decimal point ?

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: How to make it return with out decimal point ?

Is this a typo? Did you put quotes around the format like?

money( sum(sales/Rate) ,'$#,##0')

3 Replies
MVP
MVP

Re: How to make it return with out decimal point ?

Is this a typo? Did you put quotes around the format like?

money( sum(sales/Rate) ,'$#,##0')

Highlighted
kamal_sanguri
Valued Contributor

Re: How to make it return with out decimal point ?

Try this

=money(sum(sales/Rate),'$#,##0','.',',')

paulyeo11
Valued Contributor II

Re: How to make it return with out decimal point ?

Hi All

Thank you very much , all work.

Paul Yeo

Community Browser