This content has been marked as final. Show 2 replies
So you just need to replace null values with 0? The formula then would simply be zn([Amt]).
Otherwise, I'm confused as to why you need 'fake' data, because that sounds like you are falsifying information.
try this: ifnull(variables,fake value)