Reporting Tool

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!

Template.yxzp

Needed Output.xlsx

Reporting

Output

Documentation

Accepted answers

Yoshiro_Fujimori

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.

Template.yxmd

All comments

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

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.

Template.yxmd

CloudDuck

Thank you very much !!!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703