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
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