Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Returning Values Less than a certain %

Good day

Please assist in providing the correct syntax to return values that are less than 100% in the Complete table?

This would be easy if it were just values that weren't in percentage form as I would use an IF statement and <100

I%.PNG

1 Solution

Accepted Solutions
pooja_prabhu_n
Creator III
Creator III

Hi,

you can restrict using dimension limits

100%.png

View solution in original post

2 Replies
pooja_prabhu_n
Creator III
Creator III

Hi,

you can restrict using dimension limits

100%.png

Anonymous
Not applicable
Author

Thank you! That's perfect