Need help adding SUM on the front-end

Wappler General Need Help
1

i need help adding up the following.

{{reportallattendance.data.concert_all_paying_paid[0]["SUM(`concert_number_tickets`)"]}} <br>
{{reportallattendance.data.concert_all_complimentary[0]["SUM(`concert_number_tickets`)"]}}<br>
{{reportallattendance.data.concert_all_sponsored[0]["SUM(`concert_number_tickets`)"]}}<br>

this gives me from the database eg
1
0
2

But i want to ADD this all together but i cannot get it to work

 {{((reportallattendance.data.concert_all_paying_paid[0]["SUM(`concert_number_tickets`)"]||0.toNumber()) + (reportallattendance.data.concert_all_complimentary[0]["SUM(`concert_number_tickets`)"]||0.toNumber()) + (reportallattendance.data.concert_all_sponsored[0]["SUM(`concert_number_tickets`)"]||0.toNumber()))}}

i added .toNumber() but it sill does not it ouputs 1 0 2

I have a another one where i use COUNT

{{((reportallregistrationscount.data.paying_paid[0]["COUNT(`registration_type`)"]||0) + (reportallregistrationscount.data.sponsored_registered[0]["COUNT(`registration_type`)"]||0) + (reportallregistrationscount.data.complimentary_registered[0]["COUNT(`registration_type`)"]||0))}}

and this adds up perfectly ...

What am i missing....

EDIT..
SOLVED...

it was the ||0 i removed that and it worked

{{((reportallattendance.data.concert_all_paying_paid[0]["SUM(`concert_number_tickets`)"].toNumber()) + (reportallattendance.data.concert_all_complimentary[0]["SUM(`concert_number_tickets`)"].toNumber()) + (reportallattendance.data.concert_all_sponsored[0]["SUM(`concert_number_tickets`)"].toNumber())).toNumber()}
1 Like