Forum Discussion
chudson002
Dec 18, 2021Brass Contributor
CALCULATION ROUNDING UP
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") && Cod...
- Dec 24, 2021RobElliott,
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
RobElliott
Dec 18, 2021Silver Contributor
chudson002 have you tried RoundUp(....) ?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- chudson002Dec 24, 2021Brass ContributorRobElliott,
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