topic Re: RoundUp in Alteryx Designer Desktop Discussions

RoundUp

Ar13f — Sat, 18 Sep 2021 12:30:54 GMT

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

Re: RoundUp

atcodedog05 — Sat, 18 Sep 2021 12:39:29 GMT

Hi @Ar13f

Can you please share the excel which has formulas.

Re: RoundUp

Ar13f — Sat, 18 Sep 2021 12:47:39 GMT

Dear @atcodedog05

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

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

Re: RoundUp

atcodedog05 — Sat, 18 Sep 2021 12:55:36 GMT

Hi @Ar13f

How is $D$12 calculated

Re: RoundUp

Ar13f — Sat, 18 Sep 2021 13:37:23 GMT

Dear @atcodedog05

sorry for the late response .... $D$12 is 82*10%

Re: RoundUp

atcodedog05 — Sat, 18 Sep 2021 13:47:08 GMT

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 : )

Re: RoundUp

danilang — Sat, 18 Sep 2021 13:45:16 GMT

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

Re: RoundUp

Ar13f — Sat, 18 Sep 2021 14:39:04 GMT

Dear @atcodedog05 and @danilang ,

thank you all .... awesome

Re: RoundUp

atcodedog05 — Sat, 18 Sep 2021 14:42:35 GMT

Happy to help : ) @Ar13f

Cheers and have a nice day!