CALCULATION ROUNDING UP

[chudson002]

Good Day Community,

Calculation needs to round up to the next whole number. Tried many variations, but keep getting 84 (rounding down).

Text(Round(Sum(Options_1.AllItems, Value(PALT, "1") && Code.Value = "E") / CountRows(Options_1.AllItems)* 100, "[$-en-US]#"))

Calculating,  it is 84.61, need formula to round up to 85.

Recommendations?

V/R

chudson002

[#2]

@chudson002 have you tried RoundUp(....) ?

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#3 · Accepted solution]

RobElliott,
Yes, used RoundUp. The below rendered desired results.
RoundUp(Sum(Options.AllItems, Value(PALT, "1") && Code.Value = "E") / CountRows(Options.AllItems)*100,0) & "%"

Thanks for the response.
V/R
chudson002