Sum of Two Column

Hi Al,

I am stuck in one function as like below first screen condition where have two columns in a file and getting sum in total column. In second screen have only "A" column in a file, however the sum function is not working. Because B column is not available in this file.

I have many files and sometime doesn't have columns. However, want to use same workflow. is there any way to fix this issue. so that whether column is available or not. just give the result on basis of existing columns.

first Screen

Second Screen.

Thanks,

Rajeev

Workflow

Accepted answers

binu_acs

@Rhaldhar Select total column from the cross tab tool

Sum_050923.yxmd

All comments

binu_acs

@Rhaldhar to make your calculation dynamic use the transpose and cross tab tool

Sum_050923.yxmd

Rhaldhar

Hi @binu_acs thanks for looking the query. however, unable to see the total of column A and B. Can you please check again or guide how I can get the total if the case is second.

binu_acs

@Rhaldhar Select total column from the cross tab tool

Sum_050923.yxmd

Rhaldhar

Thank you so much!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335