Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

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

Re: Round down percent

floor(yourExpression, 0.005)

2 Replies
mikaelsc
Contributor III

Re: Round down percent

floor(yourExpression, 0.005)

danielco223
New Contributor III

Re: Round down percent

Thanks!

Community Browser