Any Issue with in the set Analysis Exp for Aggregating the 4 individual sum

Anonymous — Fri, 20 Nov 2015 07:52:54 GMT

Hi friends, facing an issue with the expression in set analysis

In a Text box KPI for a Measure below is set analysis expression

Based on some Names in Code need to get the sum(Transaction) respective sum([Premium], [Payment], }>} [Payment Amount])

Expected: sum(Transaction) + sum([Premium], [Payment], }>} [Payment Amount]) but with below expression no data is been populating

If I use individually the data is populating.

'Total : ' &

NUM(sum({<[Business]={'HW'}, [Code ]={ ' Withdrawals', ' Promotion ', 'Payments'},

[Transaction Date]={'>=$(=vStartDate)<=$(=vEndDate))'}>} [Transaction]), '$#,##0.00')

NUM(sum({<[Business]={'HW'}, [Transaction Date]={'>=$(=vStartDate)<=$(=vEndDate))'}>} [Payment Amount]), '$#,##0.00') +

NUM(sum({<[Business]={'HW'},

[Transaction Date]={'>=$(=vStartDate)<=$(=vEndDate))'}>} [Premium]), '$#,##0.00')+

NUM(sum({<[Business ]={'HW'},

[Transaction Date]={'>=$(=vStartDate)<=$(=vEndDate))'}>} [Payment]), '$#,##0.00')

Re: Any Issue with in the set Analysis Exp for Aggregating the 4 individual sum

jonathandienst — Fri, 20 Nov 2015 08:06:18 GMT

There are a number of problems in your expression, but this should work:

'Total : ' & Num(

Sum({<Business = {'HW'}, Code = {'Withdrawals', 'Promotion ', 'Payments'},

[Transaction Date] = {">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>}

Transaction) +

Sum({<Business = {'HW'}, [Transaction Date] = {">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>}

RangeSum([Payment Amount], Premium, Payment))

, '$#,##0.00')

If this does not work, I suggest that you upload your qvw or a representative sample.