Forum Discussion
Adding two columns from different sheet (using a filter)
I am trying to add two columns / sheet from a different sheet for the dashboard, but running into a 'Blank' statement if the corresponding row doesnt exist in one of the columns / sheet. E.g. Sh...
Try
My Sum = SUM('Sheet1'[Amount]) + SUM('Sheet2'[payment])
Try
My Sum = SUM('Sheet1'[Amount]) + SUM('Sheet2'[payment])works just fine. thank you .. It was so simple, I was over complicating it ...