Group By Total Not Adding Correctly

[Jason Hilton]

I have a vlookup that is grouping records and providing a total based on the groups. For some reason though, a simple addition of two values (1232.54 + 4543.23) is coming back as 5775.7699999999995.

The field being summed is a number field restricted to 2 decimal places. Any ideas on how to fix this so that it sums properly or possibly rounds to the decimal spots listed on the column?

Attachments:

1. 

   display.png
   

[Alexander Bautz]

Hi,
I’m not able to recreate this issue. Can you show some screenshots of the vLookup config for the field and the grouping so I can try to recreate the exact configuration?

Alexander

[Jason Hilton]

Sure thing, here is the configuration, the columns of the list being grouped and displayed, and the output I’m seeing.

Attachments:

1. 

   Capture1.png
   

2. 

   Capture2.png
   

3. 

   listdetails.png
   

4. 

   results.png
   

[SteveE]

Add this to Special configurations section under “Amount”.

{“prefix”:”$”,”decimals”:2}

[Jason Hilton]

I put that under my amount where you said to and not only do I still have the totalling issue but Amount isn’t prefixing with the $ either.

[SteveE]

Can you show a screenshot of where you put it? Also maybe put a width for the amount like 75 or 100.

[Author]

Posts