i can't find answer for this ques,i don't know how this question was related to alteryx

[haroon_sa]

16oz of alteryxium decays and losses 30% of its weight every second.how many seconds will it take until alteryxium weigh less than 1/100th of an ounce ?

[LordNeilLord · Accepted solution]

I'd build an iterative macro that reduces 16 by 30% until it equals the 1/100th of an ounce. Count the number of iterations it takes and thats your answer..

Something like this:

[haroon_sa]

thanks a lot for your answer .......can i know what is input for this work flow 

[LordNeilLord]

@haroon_sa the input was a text input with 16 as the only field

[haroon_sa]

Weight	iteration
16	12

@LordNeilLord.This is output for me,iteration was 12,but for my question there is only option is 19sec,20sec,21sec,22sec.can you please give solution  for my question..

[Reinierk]

@haroon_sa

If you set the filter tool to [Remaining Weight]<=0.01. it should work I used the same approach as @LordNeilLord, however with my change on the filter.

I came to an answer of 21 sec.

[haroon_sa]

@ReinierK

Thank you......very useful

[LordNeilLord]

@Reinierk, I got 19 when I ran it :)

[haroon_sa]

Here is my file,it is still 12, however i changed a lot

[LordNeilLord · Accepted solution]

Here's my version