Reporting Tool

[CloudDuck]

Hello,

I'm working with a few reporting tools to organize my output in a specific format. I have a sample table with two columns that need to be summarized as shown in the tool. Additionally, I need to calculate the difference between the two columns using a second input, ensuring that the final check equals zero. My challenge lies in displaying all the data while adjusting the positions of the table. I'll provide an example of the needed output format.

Thank you very much!

[shancmiralles]

hi.. just to clarify..  what is your output file format? are you just sending this via email or you need this in an excel file? 

[CloudDuck]

I apologize for not mentioning; yes,  the output as an Excel file similar to the "Needed Output.xlsx."

[Yoshiro_Fujimori · Accepted solution]

Hi @CloudDuck ,

To specify the exact cell position of output table in Excel sheet, you would need to deal with Blob tools.

If you go this way, this page Formatting data into a excel file may be of some help.

But if you can relax the requirement to simply combine the detail rows and the summary row with additional check result,

the below table might also serve your purpose.

Output Image

Workflow

I hope this helps. Good luck.

[CloudDuck]

Thank you very much !!!