Dec 18 2021 05:51 AM
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
Dec 18 2021 06:49 AM
@chudson002 have you tried RoundUp(....) ?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Dec 24 2021 06:59 AM
SolutionDec 24 2021 06:59 AM
Solution