topic Re: Sum function Not working in App Development

Sum function Not working

Nagaraj6 — Fri, 15 Nov 2024 21:46:48 GMT

Hello Guys,

I need a help

Invoice Default Currency

162.33
274.26
452.83
466.26
1120.14
269.04
1820.8
1429.2
233.16
233.16

total Invoice Default Currency :1728194

I am using this formula

[Invoice Default Currency]/SUM(if(IsNull([Invoice Default Currency]),0,[Invoice Default Currency])) as [Contribution on Sales] this query is not working showing invalid error I need only backend script.please help me.

Expected output :

Contribution on Sales

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Regards

Nag

Re: Sum function Not working

Chanty4u — Tue, 23 May 2023 10:17:22 GMT

Try this

[Invoice Default Currency] / SUM(TOTAL <Field1> [Invoice Default Currency]) as [Contribution on Sales]

Or try this

IF(SUM([Invoice Default Currency]) = 0, 0, [Invoice Default Currency] / SUM(TOTAL [Invoice Default Currency])) as [Contribution on Sales]

Re: Sum function Not working

Nagaraj6 — Wed, 24 May 2023 05:56:42 GMT

@Chanty4u Thank you!

1st formula is working for Front end (using in expression)