Help on if condition

[Anonymous]

Hi, 

I'm having a strange problem on this column formula. I have to put a flag based on 2 conditions. I wrote this formula:

Flag Presenza = if(sum(Variabili[Ore Assenza])>12 && sum(Variabili[Ore Assenza])=6,0,

if(sum(Variabili[Ore Assenza])>8 && sum(Variabili[Ore Contratto])=4,0,1)

)

I don't get why in the first row, even though I have 18 as Ore Assenza, the formule doesn't work and still gives 1 as an output, which means it doesn't recognize the case correctly.

Thank you

[technolog · Accepted solution]

Hi @Anonymous ! Why are you using SUM in formula?

Could you try:

Flag Presenza = if(Variabili[Ore Assenza]>12 && Variabili[Ore Assenza]=6,0,

if(Variabili[Ore Assenza]>8 && Variabili[Ore Contratto]=4,0,1)

)

[Anonymous]

Hi technolog,

The issue was exactly what you mentioned. I used incorrectly the sum formula so it was not calculating row by row, but in a table context. 

Thank you for the immediate answer