CKF involving %A operator

[Former Member]

Hi all,

I have this CKF in my BEx query:

(A-B) %A A

Eg: (123 - 0) %A 123

The value of this CKF is showing 100% in the query and the WebI report output.

I understand that the %A operator returns the remainder of the division operation between the 2 operands.

So in this case, the CKF should have shown 0% but is showing 100%.

Could you please tell me what should be the correct value for this CKF and also correct me if %A operator works otherwise.

Thanks and Regards,

Srilakshmi B

[k_k28]

Hi,

%A - This gives the percentage share of operand 1 and operand 2. It is identical to the formula

100 * <Operand1> / abs(<Operand2>)

So in your Case (A-B) %a A

(123-0) / abs(123) = 100%.

So the answer is correct which is showing in the report.