1 Reply Latest reply on Aug 8, 2013 6:38 PM by philmodjunk

    Is Null



      Is Null


           How would I write..... If AdditionalPhoto:Note is null then use Product:StyleName otherwise use AdditionalPhoto:Note



        • 1. Re: Is Null

               The context in which you want to do this is missing. This could be a calculation in a calculaiton field, a text field with an auto-enter calculation or a script step.

               The calculation field version might be:

               If ( IsEmpty ( AdditionalPhoto::Note ) ; Product::StyleName ; AdditionalPhoto::Note )

               But note that you have fields from two table occurrences. THe above calculation will only work if there are valid relationships linking the two occurrences.