Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QVExperts,
Expression1:
=Sum(Aggr(Sum({<DateType={'Premium'} , MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount),CERT_SQN,MonthYear,DateType))
Expression2:
=Sum(Aggr(Sum({<DateType={'Claim'} , STATUS_CD = {'L'},MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount)/Count(MonthYear),CERT_SQN,MonthYear,DateType))
Expression3:
(Column(2) / Column(1))*100
Expression3 displays correctly, if i have like this.
Suppose if i have all three expression as one, then i am not getting correct values.
Sum(Aggr(Sum({<DateType={'Premium'} , MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount),CERT_SQN,MonthYear,DateType)) /
Sum(Aggr(Sum({<DateType={'Claim'} , STATUS_CD = {'L'},MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount)/Count(MonthYear),CERT_SQN,MonthYear,DateType))
Can anyone suggest me, what is the mistake in the last expression.
Thanks,
Sasi
Created a Combo Chart .
Is it possible anyway i can hide Expression1 & Expression. Not Disabled.
Thanks,
Sasi
Just tried in Colors tab, first two expression in white color.
Then in Expression Tab, the first two expressions, unchecked the Legend.
Now only the third expression is visible in the Combo chart.
Are there any other ways. Please suggest me.
Thanks,
Sasi