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") && 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

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