View Macro each iteration Result

[PangHC]

Hi All,

Did you all experience when building a iterate macro this situation?

When you have no idea why the output is different from what you want,

hence, you remove the rows/ data to force the data run only 2 iterate, review the result.

then, you add back the rows/ data to force the data run only 3 iterate, review the result 

then 4, 5 and etc... until we found the issue.

so it was important that we can view how the result of each iterate to enable us to identify the issue quicker and more efficient.

Example output

The output may like below: (with a option to let user to choose of cause)

if input data is 3 and the macro is to multiply 2 and power of 2 every iterate. (1st iterate=3*2^2, 2nd iterate=12*2^2)

Iterate	Amount
1	12
2	48

just add one column in front to show the iterate and rest is the result.

[CristonS]

hi @PangHC, interesting use case, thank you for your feedback!  Our product team is constantly striving to make our products better, and the user feedback we received is critical in that mission. Make sure to also check out other users’ ideas, and "Like" the ones you'd like to see in the product.