# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## Pass or Fail Based on Total

Hello,

I am calculating a percentage:

Which gives me 54%, now based on that I want to add a column showing PASS or FAIL. So if the percentage is over 30% it passes and if it's under 30% it Fails. I've tried a few ways and it doesn't seem to be working.

Anyone have any suggestions?

Thank you!

1 Solution

Accepted Solutions
MVP

## Re: Pass or Fail Based on Total

=If([Actual Load Percentage] > 30, 'Pass', 'Fail')

10 Replies
New Contributor

## Re: Pass or Fail Based on Total

Can you duplicate the column, and wrap the statement in an IF statement.  Basically,

IF(Original Formula >30%, "Pass", "Fail")

MVP

## Re: Pass or Fail Based on Total

should be just this

=[Actual Load Percentage] > 30, 'Pass', 'Fail')

Contributor II

## Re: Pass or Fail Based on Total

Hey SUnny,

I tried that but it gives me an error.

Contributor II

## Re: Pass or Fail Based on Total

Hi,

Yup tried that and also not working, getting an error.

MVP

## Re: Pass or Fail Based on Total

Is this in a script or expression? Can you share a screenshot?

Contributor II

## Re: Pass or Fail Based on Total

I'm doing this as an expression.

MVP

screenshot?

Contributor II

## Re: Pass or Fail Based on Total

Sorry thought I attached it!

MVP