Data item calculations

Sometimes the answer provided back from back office APIs is in a format one would not want to show the customer.

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.

Cool Example

The following example does rely upon you having some knowledge of HTML / CSS but illustrates that with little effort something v nice can be achieved:

Pie chart driven by data items from a back office system

Here is what was added and on the right is what the user sees. Basically we are creating a pie chart. And the pie chart wedge is being filled by the amount of their housing benefit entitlement as a percentage of their rent. We can see the weekly HB amount is divided by the weekly rent and multiplied by 100 to calculate it as a percentage:

<div class=“awesome">

<div class="pie"

style="width: 200px;

height: 200px;

border-radius: 50%;

background: conic-gradient(var(--accent-color) 0, var(--accent-dark)

${

(

(Claim.Hb.Entitlement.WeeklyAmount /Claim.Hb.Entitlement.WeeklyLiability)

*100

)}

%,

var(--main-color) 0, var(--main-color-dark) 100%);”>

</div>

The only limitation with calculations is that it cannot be used on arrays/collections of data.