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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Round down percent

Hi,

I need to round down an expression so if the output is 95.59%, the measure will round down to 95.50% Below is the expression.

Sum([Amount - Shipped/Fulfilled USD])

/

(Sum([Quota - Amount])

Thanks!

1 Solution

Accepted Solutions
mikaelsc
Specialist
Specialist

floor(yourExpression, 0.005)

View solution in original post

2 Replies
mikaelsc
Specialist
Specialist

floor(yourExpression, 0.005)

Anonymous
Not applicable
Author

Thanks!