Expression not displaying correctly !!!

[#1]

Dear QV Experts,

Two Straight Tables,

1) With Certificate No, displaying the Earned Premium Correctly.

2) Without Certificate No, Not displaying Earned Premium Correctly.

Please find the screenshot below,

Please suggest me. Enclosed the QVW.

[marcus_sommer · Accepted solution]

Without the dimension Certificate_No you need an aggr-function to calculate the expression on this level and you need to include all necessary dimensions - in your case the Certificate_No and Date.

=If (MonthYear < $(vFiscalStartDt),0,

If (MonthYear > $(vFiscalEndDt),0,

sum(aggr((Sum(distinct Premium_Amt)/365) * Count( DISTINCT Date), Certificate_No, Date))))

- Marcus

[#3]

Thanks a lot. It worked.