Wednesday, March 28, 2012

put default number in a data cell of a matrix

Hi,
If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?

Thanks,
Igor

have you tried the following (as an expression):

iif(field = nothing,some#,field)

No comments:

Post a Comment