Sum of Two Column

[Rhaldhar]

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

[binuacs]

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

[Rhaldhar]

Hi @binuacs  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.

[binuacs · Accepted solution]

@Rhaldhar Select total column from the cross tab tool

[Rhaldhar]

Thank you so much!