Microvellum Knowledge Network

MaterialProperty Function Issue

Yesterday, I realized the part grain override formula (to force length/width grain direction) in our library wasn't working. 
The formula is giving a #NAME error for every part.

I'm not sure if this was customized from the standard library at some point, but the formula we have for the part grain override on all applicable parts is:
"=IF(Side_Grain_Direction="None",0,IF(MATERIALPROPERTY(MVCP,M!MFSH,M!MFSO,M!MFBO,6)="0",0,IF(Side_Grain_Direction="Length",2,4)))"

The formula is giving the error due to the MATERIALPROPERTY(MVCP,M!MFSH,M!MFSO,M!MFBO,6) function. I can't find any information on this other than this help menu text when inspecting the formula: "Used to get a value from the material file
=MaterialProperty(MVCP,M!MFSH,M!MFSO,M!MFBO,ColumnNumber)"

I understand this seems to be trying to check if a given part's material is grained or not, but does anyone know how this formula and it's parameters work, or why this would be giving a #NAME error? I've checked the materials that this should be checking, the grain value is in the 6th column and it is filled out with a value.

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review