Forum Discussion

Larstc75's avatar
Larstc75
Frequent Visitor
6 years ago

sumx difference betweeen Desktop and Service

Hi, I have a situation where a SUMX formula is behaving correctly in Desktop but provides very big numbers in the service. Never seen it before.. a bug?

 

This is the formula: 

 

Cost per Invoice Line = 
sumx(Fakturalinjer ; Fakturalinjer[Quantity]*Fakturalinjer[Unit_Cost_LCY])

 

 

see here: (No. 1019354 and the totals)

Desktop                                                                             

 
 

Service (No. 1019354 and the totals)

 

 

 

 

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Larstc75 ,

     

    Are tou sure that on both setups you have the same filters?

     

    On the images you show the last rows are dfifferent so the calculations are not comparable, this can also the way the screenshots were taken but to what I can see the service image as more lines in the calculation than the desktop.

     

    Regards,

    MFelix

     

     

    • Larstc75's avatar
      Larstc75
      Frequent Visitor
      6 years ago

      Yes I am sure. If you pay close attention, you will notice that there is a factor 100 difference on the Omk column for No. 1019354 and the Totals are just to the moon. This could not be done accidently by a filter. 

      I think it is a bug. just don't know how to fix it.