Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I need to replace empty value '-' by 0 in pivot table.
Unfortunately, it does not work.
Many thanks for your help.
Kind regards,
Nicolas.
Try,
if(Len(Expression)<1,0,Expression)
or
Alt(Expression,0)
or
if(isnull(Expression),0,Expression)
Hello,
Thanks for your return.
I have already check this post but without success.
Thank you for your help.
Regards,
Nicolas.
Hello,
I have tried but it's not working.
Thank you for your help.
Regards,
Nicolas.
In the old days we used to create zero-values in the datamodel in order to avoid the '-'s......
Maybe try this in your edit script?
If(Len(Trim(YourFieldName)) = '-', 0,YourFieldName ) as New_FieldName
I think that he's trying to eliminate the '-' in the measure not the dimension..
And I do not think that this is possible..
There's always the option to create ones own extension .....
Unfortunately not working.
Can you please post an example?
Many thanks in advance.
Kind regards,
Nicolas.