Skip to Content
Former Member
Oct 12, 2012 at 04:55 AM

Can we display multiple values from a query field in the Footer region?


H i guys,

I have field named 'vatprcnt' in my query,which includes the vat types of each items in an invoice. In the case of multiple taxes,say Vat@4 and Vat@12.5,it will be holding the corresponding values. Now I have to display the tax types,i.e distinct values of 'vatprcnt' in my footer area. I can display only the first value of the field in my footer. Tried with many formula fields to get it,but couldn't achieve it. Can any one tell me how the formula should be?or else,how can I display the values together in the footer area??