AnsweredAssumed Answered

Calculation field help!

Question asked by AndrewJudd on Dec 17, 2014
Latest reply on Dec 18, 2014 by 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

Outcomes