Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am lading a field in my script as follows:
if(len(Start)>0,(-((year(Order_Entry_Date)*12)+month(Order_Entry_Date)) + ((year(Start)*12)+month(Start))),Num(9999)) as
Leadm
It seems to work fine. My list box for the dimension displays as follows:
However, when I include Leadm as a dimension in a chart, the value 9999 is rendered as '-', as shown below
Any ideas?
Rgds
Joe
Could you please check that 9999 is really replaced by '-' in the dimension, by selecting 9999 in the list box (should result in the one '-' line table) and by deselecting option suppress zero values in presentation tab.
How is your InvVal calculated and how are all fields used related?
Could you please check that 9999 is really replaced by '-' in the dimension, by selecting 9999 in the list box (should result in the one '-' line table) and by deselecting option suppress zero values in presentation tab.
How is your InvVal calculated and how are all fields used related?
Hi Stefan
When I selected 9999, there were NO dimensions / data displayed on my table.
I think you are suggesting that the problem lies in my model.
I have made some mods and the problem seems to be sorted.
Thanks for poinitng me in the right direction.
Joe