RoundUp

Dear Alteryx Members,

I have data like below:

for calculations in excel with the Ceiling and roundup formulas it will produce data in the Sample column, after I tried it on Alteryx, only part of the data that was successfully calculated there was only 1 which was colored yellow.

is there any idea for the calculation above so that the data can be like in excel?

The following is an example of the data:

Cust	Sub Total
AA	8
BB	44
CCC	2
EE	27
GGGG	1

Input

Output

Help

In Database

In-Database

Accepted answers

atcodedog05

Hi @Ar13f

Excel Roundup is similar to Ceil which return top limit. Round and Roundup are different hence it was causing the issue. You can remove the round function and it will work as expected. Please refer the below.

Excel roundup vs ceil :

https://www.mrexcel.com/board/threads/ceiling-floor-vs-roundup-rounddown.408577/

Hope this helps : )

danilang

Hi @Ar13f

In the last record, the Round portion of the your sample formula does an initial round down to 0 which is then passed to the Ceil function Ceil(0) =0. Replace the entire Sample function with

ceil([TotalData]*[Portions]/2)

to give you

Dan

All comments

atcodedog05

Hi @Ar13f

Can you please share the excel which has formulas.

Ar13f

Dear @atcodedog05

in portion column "=(B4/$B$12)*100%"

in sample column "=CEILING(ROUNDUP(((C4*$D$12)/2),1),1)"

atcodedog05

Hi @Ar13f

How is $D$12 calculated

danilang

Hi @Ar13f

In the last record, the Round portion of the your sample formula does an initial round down to 0 which is then passed to the Ceil function Ceil(0) =0. Replace the entire Sample function with

ceil([TotalData]*[Portions]/2)

to give you

Dan

Ar13f

Dear @atcodedog05 and @danilang ,

thank you all .... awesome

atcodedog05

Happy to help : ) @Ar13f

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703