Replacing Negative results with Zero in a Query

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi M.A,

Your Solution has solved my issue.

Thank you.

Points have been awarded.

Regards,

Savitha