# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Valued Contributor II

## 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
Esteemed Contributor III

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

Just use round():

3 Replies
Esteemed Contributor III

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

Just use round():

MVP

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

Use

Num(YourExpression,'#0')

Valued Contributor II

Hi Michael

Thank , it work.

Paul