AnsweredAssumed Answered

Tricky calculation field

Question asked by AndrewJudd on Jan 19, 2015
Latest reply on Jan 20, 2015 by AndrewJudd

Title

Tricky calculation field

Post

Hi all, I have a calculation field that acts as an artwork preview for a product. There by listing all the necessary parts. I'll copy the calculation below. The issue I have is when an artwork is a video or doesn't have strict 3d dimensions as such, the dimensions fields are empty. I need therefore to drop the text part of "cm" when this is the case.

Any ideas? Thank you.

 

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

 

Outcomes