Group By Total Not Adding Correctly

Forums vLooup for SharePoint Group By Total Not Adding Correctly

Viewing 2 reply threads
  • Author
    Posts
    • #36621
      Jason Hilton
      Participant

      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:
    • #36624
      Alexander Bautz
      Keymaster

      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

    • #36631
      Jason Hilton
      Participant

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

      • #36636
        SteveE
        Participant

        Add this to Special configurations section under “Amount”.

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

      • #36651
        Jason Hilton
        Participant

        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.

      • #36652
        SteveE
        Participant

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

Viewing 2 reply threads
  • You must be logged in to reply to this topic.