Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Dec 18, 2021

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...
PowerApps
  • chudson002's avatar
    chudson002
    Dec 24, 2021
    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
RobElliott's avatar
RobElliott
Silver Contributor
Dec 18, 2021

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

 

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

  • chudson002's avatar
    chudson002
    Brass Contributor
    Dec 24, 2021
    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

Resources