Rounding up with a Pie chart

[JJJ04]

Hi everyone,

I am trying to round up calculated numbers that are displayed in my pie chart.  I have tried using a solution from a previously asked similar question but to no avail.  I think I am having problems knowing where to put the syntax to round up in my current formula.  FYI, I am pulling from a SharePoint list.

This is what I have currently:

AddColumns(GroupBy('Hotel Reviews', "ReviewDone", "DATA"), "DONETOTAL", Sum(DATA, SampleTotal/TotalRecordsforReview*100))

Here is a screenshot of the added column I had created to do the calculated sum to display for the pie chart:

I just want the "DONETOTAL" column to round-up i.e 96.96 would round up to 97 etc.

This is what my Chart looks like currently:

Any help would be appreciated! 🙂

[RandyHayes · Accepted solution]

@JJJ04 

Please consider changing your Formula to the following:

AddColumns(
    GroupBy('Hotel Reviews', 
        "ReviewDone", "DATA"
    ), 
    "DONETOTAL", RoundUp(Sum(DATA, (SampleTotal/TotalRecordsforReview)*100), 0)
)

I hope this is helpful for you.

[JJJ04]

@RandyHayes You are amazing!!  It worked like a charm!  Thank you! 🙂