Splitting the Premium monthwise in the Straight Table

[#1]

Dear QVExpert,

Premium Amount  for one year, which is of $26.

We have Warranty Start Date & Warranty End Date. Based on the period, the Earned Premium is calculated.

For two months, then (26 /365) * 60, the calculation is correct.

Now can we have monthwise in individual rows.

For example, Jan16, (26/365) *31, 2.2082191

                    Feb16, (26/365)*29, 2.06575342

Can you please suggest me.

Thanks,

Sasi

[#2]

Hi Kush,

Please find enclosed the Updated QVW.

Tried adding the Date in Calendar object.

Now in Calculated Dimension, need to limit the period bet@ween $(vFiscalStartDt) and $(vFiscalEndDt)

The chart should display like this,

Please suggest me

Thanks Again

[#3]

Hi Kush,

I am limiting the MonthYear display based on the FiscalStartDate & FiscalEndDate.

The values are not limited. We need to modify the Expression as well.

Please find both the qvw & the screenshot.

Please suggest.

[#4]

Hello Kush,

I modified in the expression & it is working fine

Please find enclosed the qvw.

Please correct me if i am wrong.

Thanks,

[Kushal_Chawda]

That's gr8.