5 Replies Latest reply on Dec 18, 2014 12:55 AM by AndrewJudd

    Calculation field help!

    AndrewJudd

      Title

      Calculation field help!

      Post

      Hi there, I'm trying to work on a calculation field for a database. I have three fields for dimensions - height, width and depth. These fields are pulled into a calculation field in the database for easy copying, pasting, emailing etc. The issue is. Sometimes there won't be a depth. So how do I remove the formatting if depth is empty? This is what I have but it is not working correctly. Images attached. THANK YOU

      Artist &¶ &TextStyleAdd(Title;Italic) &¶ & Date &¶ &Medium &¶ & Heightcm  & If (IsValid ( Heightcm ) ; " x " ) &  Widthcm & If (IsValid ( Depthcm ) ; " x " )  & Depthcm & " " & "cm" & ¶ & Edition Number &  ¶ &  Inventory # & ¶ & ¶ & ¶

      Screen_Shot_2014-12-17_at_18.46.24.png