Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
narender123
Specialist
Specialist

Set Decimal in script level

Hi All,

I want a result like :

suppose my actual result which  is coming 1234.229 and i want to convert it into 1234.23

formula in script is:

Sum(amount)/30

so what function i have to use in this to take first  2 digits after decimal.

Thanks in advance.

Narender

2 Replies
MarcoWedel

Num(Sum(amount)/30,'#0.00')

maxgro
MVP
MVP

in script

round(sum(amount)/30, 0.01)