Hi Could you please explain me why below function is not working in Issue sheet. I want to get 0 for Stock availability column if, item qty in table 3 is less than the same item quantity in table 2., and to get 1 for Stock availability column if, item qty in table 3 is more than the same item quantity in table 2.
Below is the formula i tried:
=IF(Table2[Item]:[Quantity]<Table3[@[Item]:[Quantity]],0,1)
Much thanks in advance!