Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hello Kush,
I modified in the expression & it is working fine
Please find enclosed the qvw.
Please correct me if i am wrong.
Thanks,
That's gr8.