How to create percent Of Total

[weird_guy]

Hello Team,

Could you please help to create calculated field with percentOfTotal function ?
I want to show % instead of numbers for each status NEW/CAPTURED/DECLINED.

Thank you.

[Shahid_Muhammad]

Hi @weird_guy

Using this you were able to find the percent of total. Change the fields accordingly.

percentOfTotal(sum({Order_id}),[date]

[weird_guy]

Hello @Shahid_Muhammad

Thank you for your attention to this matter

Ive received an error. What does it mean?

[Biswajit_1993]

Hi @weird_guy ,

Can you make a slight change to the calculation? Instead of using the history_date_field, just leave the square brackets blank and check if it works.

percentOfTotal(sum({Order_id}),[ ])

Thanks & Regards
Biswajit Dash

[weird_guy]

Hello @Biswajit_1993

The same issue

Expression percentOfTotal(sum({order_id}),) for function SUM has incorrect argument type SUM(String). Function syntax expects ‘SUM(Number)’.

[prantika_sinha]

Please change the aggregate function to count instead of sum.

[Biswajit_1993]

HI @weird_guy ,

Please follow the changes highlighted by @prantika_sinha, and I think you will get the correct result

Thanks & Regards
Biswajit Dash

[weird_guy]

Team u r stars.
It works!
Thank you vm!