SOLVED

CALCULATION ROUNDING UP

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 (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
www.000webhost.com