Forum Discussion
Syndicate_Admin
Administrator
AdministratorMin give error due to blank or empty value
Hello, I have follow measure, that works well with most part of values, but it shows error in some cases. if(values(Mastermaterialsap[DChain-spec.])="E51",Measurement[Total months availa...
Finally if it has worked. Thanks a lot
mahenkj2
Solution Sage
Solution SageHi Syndicate_Admin ,
The description of error "A table of several values was provided where a single value was expected." indicate that sometime result of one of your condition of if statement is retruning more than one value in evaluating expression, and as you say it is not happening all the time but with certain values/data, then can you please look at that data for both condition of your if statement. Else please share some data sample here.
Hope it helps!