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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Handling decimal part of a BigDecimal

Hello,

 

I would like to know how to establish a format rule for the decimal part of a BigDecimal.

I want the numbers that have 0 or 5 in the decimal part to be 1 (valid), else 0. Here's an example:

0683p000009M6PH.png

 

How would it be the expression?

 

Thank you!

Labels (2)
1 Solution

Accepted Solutions
ThWabi
Creator II
Creator II

Hello marczb,

 

try this, for example:

 

0683p000009M6Kw.pngget BigDecimal part

 

Best regards,

 

Thomas

 

View solution in original post

2 Replies
ThWabi
Creator II
Creator II

Hello marczb,

 

try this, for example:

 

0683p000009M6Kw.pngget BigDecimal part

 

Best regards,

 

Thomas

 

Anonymous
Not applicable
Author

It works, thank you!!