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

Replacing Negative results with Zero in a Query

Hi,

In my query i need to calculate the delay in payment.I have calculated the delay using CKF and Formula Variables.But few of the values are negative as the payment was made before the due date.

Is there an option were i can replace only the negative values with a Zero?

Do help me with the steps.

Thanks,

Savitha

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2008 at 12:26 PM

    Hi

    Hide the calculated Keyfigure and create a new formula.

    In the new formula create the condition

    CKF > = 0 * CKF + 0

    This means that if the calculated Keyfigure which has the values Gt or Equal to 0 will display the actual value in Calculated Keyfigure and if it is less than 0 then it will Display 0. So Negative values will be o.

    Regards

    M.A

    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.