3 Replies Latest reply: Apr 2, 2015 12:55 PM by Yeo Poh sai

# 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_))

• ###### Re: How to make my display from xxxx.xxx to xxxx ?

Just use round():

round(<your long expression here>)

• ###### Re: How to make my display from xxxx.xxx to xxxx ?

Hi Michael

Thank , it work.

Paul

• ###### Re: How to make my display from xxxx.xxx to xxxx ?

Use

Num(YourExpression,'#0')