I have a template report which outputs the data to a table. However the cost fields are calculated fields & even if there is a zero value, a 0 is both sent to the Google sheet & to the template. The expression to calculate the cost field is: (ANY(SELECT(BevDB[CostPerUoM],[Ingredient]=[_THISROW].[Ingredient1])))*[Qty1]
I have tried the following IF statement to have the output blank, BUT it still outputs a 0 & not a blank cell. Any help is appreciated. Cheers
SOLVED with this formula thanks to @Steve & @1minManager for helping me out.
ANY(LIST(ANY(SELECT(BevDB[CostPerUoM], ([Ingredient] = [_THISROW].[Ingredient1]))) * [Qty1]) - LIST(0.0))
LinkedIn
Twitter
