Expression Difference of Value

[#1]

Dear QVExperts,

In the straight table below,

Expression1,  as Claim Count [ There are total 5 claim counts]

Expression2, which shows the value whether claim there or not.

Expression3 as Column(1)/Column(2)

Now i need to display as 5 / 313.33 as 1.6 in the cumulative total.

But i am getting as 22.162

Can anyone suggest me on this.

Thanks,

Sasi

[sunny_talwar]

Are you using a total mode here? I think setting the total mode to expression total should do it. Can you try doing that?

[#3]

Hi Sunny,

Hope you are doing great.

Expression Total, the Expression2 itself not displaying correctly.

{here i am taking the day differences between the retrieval divided by total number of days for a year]

((IF([EXT_WRNTY_STR_DT]>$(vFiscalEndDt),0,

IF([EXT_WRNTY_END_DT]<$(vFiscalStartDt),0,

IF([EXT_WRNTY_END_DT]<$(vFiscalStartDt),$(vFiscalStartDt),

IF([EXT_WRNTY_END_DT]>$(vFiscalEndDt),$(vFiscalEndDt),[EXT_WRNTY_END_DT]))))

-

IF([EXT_WRNTY_STR_DT]<$(vFiscalStartDt),$(vFiscalStartDt),

IF([EXT_WRNTY_STR_DT]>$(vFiscalEndDt),$(vFiscalEndDt),[EXT_WRNTY_STR_DT]))+1)

/

DayCount )

That's why Expression3 going for Sum of Rows.

Please suggest me

[sunny_talwar · Accepted solution]

May be try like this then:

Sum(Aggr(Expression1, Dimensions))/Sum(Aggr(Expression2, Dimensions))

Replace Expression1, Expression2 and Dimensions with their respective content

[#5]

Thanks Sunny. It worked for me. Excellent.