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)
Thanks for your help
Go to Solution.
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.
View solution in original post
Try this calculated column formula
Hope this helps.
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!