SOLVED

CALCULATION ROUNDING UP

Brass Contributor

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 Replies

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

 

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

best response confirmed by chudson002 (Brass Contributor)
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
1 best response

Accepted Solutions
best response confirmed by chudson002 (Brass Contributor)
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

View solution in original post