AnsweredAssumed Answered

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

Question asked by monteric on Feb 16, 2017
Latest reply on Feb 20, 2017 by 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))

Outcomes