Counting the results for the average of users

[#1]

I have a data of customer_code which have some identical due to the invoices. i have to count the invoices for each customer_code and add them up in which i divide it by 12 months which gives me the average. i do this for 2 different years 2016 and 2017. the averages are then compared if the average for year 2016 is higher than 2017 i get the result declining vice versa. how do i count the result into two columns for declining and growing.

[adamdavi3s]

This isn't much to go on but you can simply use the names you've given your expressions

if(2017expression < = 2016expression, 'Declining','Growing')

[sasiparupudi1]

Something like Below?

if(

avg(Aggr(Count({<Inv_Year={2016}>}InvoiceNo),customer_code,Inv_Month))

<

avg(Aggr(Count({<Inv_Year={2017}>}InvoiceNo),customer_code,Inv_Month))

,'Growing','Declining')

[#4]

Thx got it to work

[#5]

Thx it worked