KEY FIgure Property

[Former Member]

Hi All,

I am creating KPI by using update routine,i will caluculate TAT KPI like if Closed date is > Submitted date, as per this i will caluculate but some times if submitted date >closed date it is showing for that 0 , but as per our business requrement it has to show # or space,

TAT Property is Quantity with floating point.there is any other option to display like this in cube it self ,

I changed Bex like all zero will b edisplayed like # but in this case it is showing TAT which is having 0 also #, it should not show lik e this ,

Can you please suggest me.

Thanks.

[Former Member]

you need to modify update routine to explicitely put # or space in the "else" clause of if condition.

If the condition is put only for Closed date is > Submitted date & nothing is specified for submitted date >closed date, then system will populate TAT KPI with default value (i.e.0) when submitted date >closed date.