IF(AND) CONDITICION

[k1ko92]

Hi all,

Someone can help me to improve this IF(AND) ?

My formula is considering BLANK() as a 0, when I have BLANK() on column Cumplimiento should return 0.

Column Eval Pendiente = Text

Column Cumplimiento = Number

Column Pontuacion = Number

[v-yiruan-msft · Accepted solution]

Hi @k1ko92 ,

You can change the formula of your calculated column [Pontuacion Disponible] as below, the part with red font is updated ones....

Pontuacion Disponible =

IF (

ISBLANK ( 'UNPIVOT KPI'[Cumplimiento] ),

0,

IF (

AND ( 'UNPIVOT KPI'[Eval Pendiente] <> "", 'UNPIVOT KPI'[Cumplimiento] = 0 ),

'UNPIVOT KPI'[Pontuacion] * 1,

0

)

)

Best Regards

[SpartaBI]

Hey, not sure exactly what you are trying to do but maybe this will help. These are the rules:
" " = BLANK ()  => TRUE
" " == BLANK ()  => FALSE
0 = BLANK ()  => TRUE
0 == BLANK ()  => FALSE

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂