How can I do a calculation with fields retrieved from the back office?

Sometimes you might want to show data that is retrieved from the back office in a different way. OneVu now has the ability to do calculations to derive a value that is not present in the back office APIs. 

For example, entitlement to benefit is always passed as a weekly value. But what if you wanted to show this as a monthly value for someone that is paid monthly.

So let's say you wanted to show this:

- You are entitled to: £100.00 per week

- This is the same as: £433.33 per month

The back office APIs for all three back-office systems will give the value weekly so there will be a data item for weekly HB entitlement. As we want to show the monthly value we can do a calculation to get this.

The following is an example Data Item for weekly HB award (Capita back office)

${Claim.Hb.BenefitAward.AwardAmount}

To calculate the monthly amount I use the following:

${(Claim.Hb.BenefitAward.AwardAmount * 52 / 12)}

Therefore to do a calculation one needs to add regular brackets () around the data item name and the calculation to be done. So in this case it will automatically multiple the weekly value by 52 and then divide that by 12 to get the monthly amount.

If it were a council tax benefit award you might want to show it as an annual award so:

${(Claim.Hb.CouncilTaxAward.AwardAmount / 7 * 365)}

I.e. the value is being divided by 7 to get the daily award and then multiplied by 365.

Calculations can be as complex as you like. The only thing that's important is understanding the format that needs to be used.

In the following example, say we want to calculate:

Weekly Council Tax Charge - CTS non dep deductions - (20% of Excess Income) to get to the CTS award.

The following is the calculation for this:

${

(

(CurrentEntitlement.Lcts.Breakdown.Weekly-CurrentEntitlement.Lcts.Breakdown.NonDepDeduction)

-

(CurrentEntitlement.Lcts.Breakdown.ExcessIncome * 20 / 100)

)

}

I.e. the two separate calculations need to be inside brackets. And the overall calculation needs to be inside brackets too.

Also of note in the above is that is possible to add / subtract / multiply / divide back office values together.