topic how to show Invoice count in App Development

how to show Invoice count

madnanansari — Tue, 16 Jan 2018 09:40:18 GMT

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).

Re: how to show Invoice count

sunny_talwar — Tue, 16 Jan 2018 09:43:57 GMT

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

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

Re: how to show Invoice count

sunny_talwar — Tue, 16 Jan 2018 09:44:36 GMT

Or just a simple if statement

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