Dynamic HTML Table Data error

[sgr]

Through flow i have dynamic HTML table.  got total expenses and budget from dynamic HTML table. 

i tried to calculate  sum and percentage from below formula but I got error in dividing..
It shows below error.

mul(div(float(variables('TodateExpenses')),float(variables('Budget'))),100)

It's seems it is trying to divide empty body field. Is there way out?

Any tips?

[abm · Accepted solution]

Hi @sgr 

Add an If condition to check variables('Budget') is null or use an expression to check the length > 0 of variables('Budget').

Thanks

[sgr]

you are correct, some time solution is so simple but we overlooked. thank you for your suggestion.