Deleting specific rows if fee amount is empty

Help StudioX
,
1

Hi experts,

I’m working on an automation where I need to use an Excel file to create a letter. In this Excel file, I want to include the fee amounts only if they are not empty or null. If a fee amount is either “N/A” or “0,” I would like to either delete or hide the corresponding row in the table. For example, if the security deposit is “N/A” or “0,” I want to hide or delete that row. However, I need to ensure that the total amount is still included in the final PDF. Could you please advise on the best approach to achieve this?

image
image696×124 2.97 KB

Thanks

2

Hi @lqxchan

Is there any formula in the total column?

Regards

3

Hi @vrdabberu

There’s no formula in the total column. The values in the total column are copied from another Excel sheet.

Thanks