This is what I want to achieve from the above table. "If the same Amount appear twice per Month per client selected, a message should be displayed like "Electricity & Gas are combine on one invoice" ". Please I will appreciate any help on how to achieve these.
It worked thanks. Please I need another assistance: Please see attached.
I want to be able to display a message each time the column VS is greater than one and the months having the counts greater than one should also be displayed per customer selection. Here is the formular I used to arrive at the figures in the column VS :
Below is the expression one of your colleagues helped me with but it did not work because he said I need to change VS into a formular some how. But I don't know how to do that. Please any help on how to figure that out or another solution?
'The same invoice appeared more than once in the months of ' & Concat(If(Aggr(Count (VS),Jaar,Maand) >1,Maand),' & ')