Tricky Gross amount calculation

[AH]

Hi,

I have a scenario like this, I have to calculate the Gross Amount summing up the SalesRegister, Service and FreeText amount. The problem here is, I have to exclude couple of GL account from FreeText while summing up. And this GL account shouldnt be excluded from SalesRegister and Service while summing up.

My Expression is like this:
=num(Sum({<SalesType = {'SalesRegister', 'FreeText', 'Service'}>}TotalLineAmountInReportCurrency),'##,##0')

Accounts to be excluded from Freetext only is: 100, 101, 115, 120, 430 and 420

Its sounds little tricky to me to calculate this.

Any Suggestions? Please

Thanks,
Shan

[agomes1971]

Yes but you should test also with an excel to see which is the real result...

André Gomes

[anbu1984]

Red marks is a bug in Qlikview

=num(Sum({<SalesType = {'SalesRegister',  'Service'}>}TotalLineAmountInReportCurrency) +

Sum({<SalesType = { 'FreeText'},GlAcct-={'100', '101', '115', '120', '430', '420'}>}TotalLineAmountInReportCurrency)

,'##,##0')