Forum Discussion
Condition With hours
Hello Everyone!
I need your help in calculating a column which give me either a 1 o 0, a 1 when in the column "HORA_INGRESO" is after 10:30 and the column "CD" is 1011, other wise the result wuld be 0.
I am usig this calculated column, and didnt work
HOUR = IF(CABECERAPEDIDOSAP[HORA_INGRESO]>"10:30" && CABECERAPEDIDOSAP[CD]="1011" ;1;0)
Any Ideas?
Thanks for your help
Use the following formula for your calculated column:
IF(Times[Time]>TIME(10, 30, 0) && Times[CD]="1011",1,0)
You'll need to translate that to your column names, but the key is you are comparing your time column to the TIME() function. The && allows you to add additional comparisons to the IF() statement.
Hi,
Try this calculated column formula
=IF(AND(CABECERAPEDIDOSAP[HORA_INGRESO]>TIME(10,30,0);CABECERAPEDIDOSAP[CD]="1011");1;0)
Hope this helps.
2 Replies
Use the following formula for your calculated column:
IF(Times[Time]>TIME(10, 30, 0) && Times[CD]="1011",1,0)
You'll need to translate that to your column names, but the key is you are comparing your time column to the TIME() function. The && allows you to add additional comparisons to the IF() statement.
Hi,
Try this calculated column formula
=IF(AND(CABECERAPEDIDOSAP[HORA_INGRESO]>TIME(10,30,0);CABECERAPEDIDOSAP[CD]="1011");1;0)
Hope this helps.