Skip to Content
author's profile photo Former Member
Former Member

KEY FIgure Property

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 07:49 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.