Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Wrong Sub Total

Hi All,    i am having trouble getting correct subtotal in the unit price calculation shown in the picture. The numbers below the subtotal works fine but the total is wrong it should have been 5,85...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    It seems like a common measure calculation issue on total level.(when measure calculated on total level, it will direct calculated with summary row contents instead of calculate drill to detail row and summary calculation result)

     

    For example:
    Detail level: 2*3,3*4,5*6
    Total level: (2+3+5)*(3+4+6)

     

    You can take a look at following link to know more about this:

    Measure Totals, The Final Word

     

    Regards,

    Xiaoxin Sheng