7 Replies Latest reply on Feb 20, 2017 11:36 AM by monteric

    Removing "?" from displaying when no data is found.

    monteric

      As the attached shows where there is no data a “?” is displayed as well as the concatenated text.  Can I have nothing display instead?  The calc is the following. 

       

       

      If(  IsEmpty(GetRepetition(BleedWidth;1)) and IsEmpty(GetRepetition(BleedHeight;1)); ""; GetRepetition(BleedWidth;1) & " x " & GetRepetition(BleedHeight;1) & ", ") &

      If( IsEmpty(GetRepetition(BleedWidth;2)) and IsEmpty(GetRepetition(BleedHeight;2)); ""; GetRepetition(BleedWidth;2) & " x " & GetRepetition(BleedHeight;2) & ", ") &

      If( IsEmpty(GetRepetition(BleedWidth;3)) and IsEmpty(GetRepetition(BleedHeight;3)); ""; GetRepetition(BleedWidth;3) & " x " & GetRepetition(BleedHeight;3) & ", ")&

      If(  IsEmpty(GetRepetition(BleedWidth;4)) and IsEmpty(GetRepetition(BleedHeight;4)); ""; GetRepetition(BleedWidth;4) & " x " & GetRepetition(BleedHeight;4) & ", ")&

      If( IsEmpty(GetRepetition(BleedWidth;5)) and IsEmpty(GetRepetition(BleedHeight;5)); "";  GetRepetition(BleedWidth;5) & " x " & GetRepetition(BleedHeight;5) & ", ")&

      If( IsEmpty(GetRepetition(BleedWidth;6)) and IsEmpty(GetRepetition(BleedHeight;6)); ""; GetRepetition(BleedWidth;6) & " x " & GetRepetition(BleedHeight;6) & ", ")&

      If( IsEmpty(GetRepetition(BleedWidth;7)) and IsEmpty(GetRepetition(BleedHeight;7)); ""; GetRepetition(BleedWidth;7) & " x " & GetRepetition(BleedHeight;7) & ", ")&

      If( IsEmpty(GetRepetition(BleedWidth;8)) and IsEmpty(GetRepetition(BleedHeight;8)); "";  GetRepetition(BleedWidth;8) & " x " & GetRepetition(BleedHeight;8) & ", ")&

      If( IsEmpty(GetRepetition(BleedWidth;9)) and IsEmpty(GetRepetition(BleedHeight;9)); ""; GetRepetition(BleedWidth;9) & " x " & GetRepetition(BleedHeight;9) & ", ")&

      If(  IsEmpty(GetRepetition(BleedWidth;10)) and IsEmpty(GetRepetition(BleedHeight;10)); "";  GetRepetition(BleedWidth;10) & " x " & GetRepetition(BleedHeight;10))