Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
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():

round(<your long expression here>)

View solution in original post

3 Replies
Anonymous
Not applicable

Just use round():

round(<your long expression here>)

MK_QSL
MVP
MVP

Use

Num(YourExpression,'#0')

paulyeo11
Master
Master
Author

Hi Michael

Thank , it work.

Paul