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