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

Sum of first two column is calculated incorrectly

Dear all,

I have two blocks for which the business partner ask to see the sum of them at the end of the block as an extra column.

For the first one I did the calculation and it is ok. However ı am seeing incorrect values after ı dıd the same formulas for the second block, which can be seen as attached

I wonder what the probable reason for this discrepancy. and what type of formula i should write in order to reach the proper solution.

R.

Eddy

Problem.jpg (61.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2013 at 03:42 PM

    Hi Eddy,

    For your problem, there are two possibilities.

    • Same formula in both blocks with Same objects
    • Same formula in both blocks with different objects

    If same formula for both blocks with same objects then why dont you create a variable and use it in both blocks.

    If same formula for both blocks but different objects, then check following

    • Make sure the formula is correctly made
    • Make sure the data in objects are compatible with formula

    The provided screen shot is not much helpful to understand your problem. Can you provide more detailed one? Also can you provide formula used in both blocks ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 12, 2013 at 08:41 PM

    Hi,

    What is the table structure and also as Hardik posted , please provide more information on columns and the calcualtion you are using.

    Thanks,

    Jothi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2013 at 08:14 AM

    Hi both,

    I actually have two different formula in each table and with the same measure.

    I thought of changing the syntax a bit but I couldn't found and corrective solution.

    Attached is a descriptive document regarding the issue.

    First one is right and the second is incorrect calculation result I must change to

    0

    28418

    0

    0

    7941

    22529

    58888

    Regards.

    Eddy.


    tables.jpg (103.0 kB)
    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.