Increase/Decrease in % with null

[b737]

Hi,

I am presenting on map (10 regions on one map) increase/decrease of sales- current year compared to the same period last year in percent (%). I have created Data Item which is calculating that % and showing at the map according of the measure.

The problem which I have is than in last year I do not have sales 0 (null) and now I have 5 (example). Since it is divided by zero (divx0) it returns on map the same color like it was no change (like 0). I have crated IF-THEN statement to, so if last year is null to return only number of sales for current year, since it can not calculate percent.

Now, Cognos see that like number 5 and color in pallet like it is increase of 5%. I want to tell him when it is situation like this to use some special pattern on color, or something else. How to do that.

Thanks

[karthik.kadambi]

Hi,

Can you somehow say it it's divide by 0 then 999999% using Data Format property and assign a color for this?

[b737]

Yes, I can tell if [previous year] is null then (9999%), but in that way Cognos will color that as a biggest increase and I do not want that.

I want if it is possible if  [previous year] is null to put some other pattern or color, so that user knows that in last there was not sales and now has, and to show number of sales. But there is only one color pallet, so I don not know how to do that