8 Replies Latest reply on Dec 28, 2018 1:21 PM by Raj Cheruvu

# Calculation field/True|False

Hi there,

this is my data set:

I would like to crate a data field, which shows me "reached" if B matchs with A. If there is no match between A & B, then "not reached"

This is my formula:

IF B = NULL then "not reached"

ELSE "reached"

END

and this is my result:

Why I have "reached" if  B doesn't match with A?

Thank you!

Best

Dilyana

• ###### 1. Re: Calculation field/True|False

Hi Dilyana,

Put the NULL in single quotes in your formula

eg: 'NULL'

So the calculation looks :

IF B = 'NULL' then "not reached"

ELSE "reached"

END

You will get them as 'not reached'

Christina

• ###### 2. Re: Calculation field/True|False

Hi

try this

if A=B then 'reached'

else 'not reached' end

Also, Null is not zero and not value. Just no value given Or missing/empty cell, speaking generally. thus your calculation didn't work. Therefor, you should use ISNULL function not NULL value.

Sorry i was replying from my phone

hope it helps

Sherzod

• ###### 3. Re: Calculation field/True|False

Hi Dilyana,

Put the NULL in single quotes in your formula

eg: 'NULL'

So the calculation looks :

IF B = 'NULL' then "not reached"

ELSE "reached"

END

You will get them as 'not reached'

Christina

• ###### 4. Re: Calculation field/True|False

Try this:

IF ISNULL(B) then "not reached"

ELSE "reached"

END

1 of 1 people found this helpful
• ###### 5. Re: Calculation field/True|False

Katta rahmat , Sherzobek

• ###### 6. Re: Calculation field/True|False

Salom Dilyana

Hursandman yordam berganimdan. Qanday savol bolsa shu erga post qiling. Juda kopchilik yordam beradi. Mayli omad sizga

Sherzod

• ###### 7. Re: Calculation field/True|False

Christina

have you tried the same formula on your sample data? Did you get the correct answer? Because null is is not a value rather a missing empty cell. ISNULL function should be used. I hope it helps

sherzod

• ###### 8. Re: Calculation field/True|False

Hi,

When I try a similar T/F calculation I am not getting two values.  I am only getting one value.  The pill is a measure.  What I am trying to get is two options to color code a bullet chart.  If the volume 2018 is greater than volume 2017 then "Dark Blue" Else "Light Blue".  When I try to the calculation, I get "Dark Blue" without the "Light Blue" option.  I have seen other people do this in their .twbx books but I am unable to.  Any input would help...