Can a LOOKUP formula introduce errors in decimals?
The formula deduces from OnHand column the sold Quantity stored in Sales Table of each Item.
All the integer results are perfect, but decimals are not subtracting correctly. Usually the result of this subtraction is larger so I wonder if LOOKUP is rounding up?
([OnHand] - LOOKUP([_THISROW].[Item],SalesTable,Item,Quantity))
LinkedIn
Twitter
