Sum function Not working

[Nagaraj6]

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

[Chanty4u · Accepted solution]

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]

[Nagaraj6]

@Chanty4u  Thank you!

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