i have a field(x) which has some null values against (y)
so i want to do a mapping load where i need to check the 0 values
so wherever is 0 it shud consider it as null so the value displayed in field y shud be correct
how to do that.
Dear Dynamic Girl,
Do you mean if x is null then treat as if it is zero?
try Alt(x,0) either in script or in a chart expression.
Alt(x,0) will return x if it is numeric and will return 0 if non-numeric (including null).
X and y are fields in difrnt tables,actly we are showing count(distinct x) and y field has 4 values ,say count(distinct x ) is Shwng 40 value but if I select all the 4 values in y field so the count is around 35 so there is a difrnce in values ,we are assuming there is some 0 values against this,so wat I want to try replace all 0 with nulls only