Kyle 
-
Re: Formula for blank value in lookup function
Hello, If the open quantity is number formatted, then you would have to write IF Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] = 0 THEN Quantity Reqd ELSE Open Qty by Bucket ID…3 -
Re: Formula for blank value in lookup function
Hi Prabakaran, You have to put apostrophes around the Report Date (Date) line item because of the parenthesis. Attached is a screenshot to show the formula. I hope this helps! Kyle3
