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

Incorrect result after formula aggregation

Hi,

I need to calculate a formula based on order value.

In pseudo code what i do is (is order value <= 100 the formula1= order value else formula b = order value)

When i work on the document detail, i get good results. The issue is when i summarize the query to a level higher than document (Zone, Brand etc'). The formulas gets calculate based on the summary rows, not based on the calculations of the individual results.

I understand that saving the formulas as CKFs and setting the calculation to "before aggregation" should help, however, after trying to create the CKF, it is impossible to set the calculation mode to "Before".

Has anyone experienced this sort of issue, and knows how it can be handled? This seem to be quite a basic feature to use, and still it doesn't work for me.

Regards,

Xibi

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2006 at 04:31 PM

    Try to do formula as calculated KF. In CKF attributes, set calculate before aggregation. It should works

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 04:37 PM

    I have same problem!

    Have you solved ? If yes can you send me solution.

    carlo.mosole@derga.it

    Thank in advance.

    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.