how to show Invoice count

[madnanansari]

I am working on a sales table which has monthly summary till 2016 and have detail transactions for 2017 and 2018.

For the summary table I have  a column 'Invoice Count' which is the total number of sales invoices made during the month whereas the detail transaction have Sales Invoice No so her we put a count function to count the total.

How can I show the count of Sales Invoices in one single column? till 2016 it should show sum(Invoice Count) and after that it should show count(Invoice No).

[sunny_talwar]

If one will be null when other have value, you can try this

Count(Alt([Invoice Count], [Invoice No]))

[sunny_talwar]

Or just a simple if statement

If(Year = 2016, Count([Invoice Count]), Count([Invoice No]))