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

CKF involving %A operator

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 10:23 AM

    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.

    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.