RoundUp

[Ar13f]

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

[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

[Ar13f]

Dear @atcodedog05 

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

[atcodedog05 · Accepted solution]

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 · Accepted solution]

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!