Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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.