Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Min 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...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Finally if it has worked. Thanks a lot

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Hello, no. It has not yet been resolved. I've tried the indicated but it doesn't work. Any more ideas? Thank you

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

=If(values(Mastermaterialsap[DChain-spec.])="E51",
Measurement[Total months available],
MINX(
{ SEM1,SEM2,SEM3,SEM4,SEMAF2},[Value])
)

if this does not help you, then we need to look at your file