2 aggr function in single expression

[narender123]

Hi Team,

I have two database (old and new database).suppose database 1 have the amount up to mid of the 2015 year.

Database 2 have amount start from mid of the 2015 year.

So I have merged both database dimensions,amount etc.

Expression is:

=aggr(sum({<Flag={'B'}>}TOT_TAX_AMT),TAX_CODE)+sum({<Flag={'A'}>}aggr(only(TOTAL_REVENUE),key))

Both database sum is shown in upper expression.

You can see aggr is used in both parts of the expression. Due to 2 aggr function in the single expression, the year 2015 amount is not showing on the table. But for 2017,2016,2014,2013, the amount is coming in the report.

Note: I am not taking dimension in the table, I am only showing expression in table.

Please tell me how to sort out this problem.

Thanks,

Narender

[stabben23]

Hi,

could it be that you just need to aggregate the first Expression:

sum(aggr(sum({<Flag={'B'}>}TOT_TAX_AMT),TAX_CODE))+sum({<Flag={'A'}>}aggr(only(TOTAL_REVENUE),key))

[Anil_Babu_Samineni]

If DB1 and DB2 same structure and then call up using concatenate

DB1:

Select Flag, TOT_TAX_AMT, TAX_CODE, Key;

DB2:

Select Flag, TOTAL_REVENUE as TOT_TAX_AMT, Key;

Then may be this?

Aggr(Sum({<Flag = {'A', 'B'}>} TOTAL_REVENUE),Key)

[narender123]

Hi Johansson,

It is Showing wrong data.

Thanks,

Narender

[narender123]

Hi Anil,

Both db has different structure.

Thanks,

Narender

[Anil_Babu_Samineni]

Would you share sample application

[narender123]

Hi Anil,

I cant share with you.Because it has multiple dimension and script created in multiple phases.

[Peter_Cammaert]

No problem. We only need the final QVW without script or DBs.