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
¡Resuelto! Ir a solución.
@Rhaldhar to make your calculation dynamic use the transpose and cross tab tool
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.
Thank you so much!