Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I work out percentage in expression

Hi, I need to work out a % of a number in an expression and this just isnt working :-

 

count(if(len([Default Notice Date]>'0'),BP)/count(if(len([Registration Date]>'0'),BP)*100))

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

HI

Try like this

count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.