Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Master

## How to make my display from xxxx.xxx to xxxx ?

Hi All

May i know how to modify the below expression , so that it will return with out dwcimal point. I expected it display 194. Now it display 193.68607618441

=(month*30*Avg({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (STK_OPEN+STK_CLOSE)/2))

/(Sum({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (COGS_+COGS_INT_)/1))

+

(month*30*Avg({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (AR_CLOSE+AR_OPEN)/2))

/sum({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (REVENUE+REVENUE_INT_)/1)

-

-1*(month*30*Avg({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (AP_CLOSE+AP_OPEN)/2))

/sum({\$<year = {\$(=max(year))}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} (COGS_+COGS_INT_))

1 Solution

Accepted Solutions
Anonymous
Not applicable

Just use round():

3 Replies
Anonymous
Not applicable

Just use round():

MVP

Use

Num(YourExpression,'#0')

Master
Author

Hi Michael

Thank , it work.

Paul

Community Browser