Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Sometimes when a calculated dimension is null the next column dimension doesn't appears and i don't know why.
i try to put the condition if(Isnull(field) ,'-',field) on alld imension but doesnt work's.
someone can help me?
Many thanks for your supports
no, nothing :-((
ut you also remove aggr in the expressions?
But I don't understand because if i don't filter all dimensions appears while, after filter, some dimensions hide.
if there aren't any solution i'll try to calulate all directly in the query.
Regards
Now works.
in dimension (also in Surface and Qty column) instead of if isnull() i use if(AGGR(count(Field), NODE)=0,'-',field) and all columns apperas also when filter is active.
Many thanks for your help