Sum in Formula Fields

galawij · Post by **galawij** » Thu Apr 05, 2012 12:35 am

Hello,
how can I Multiply two fields in a Formula Field that one of fields is a sum of columns.
when I use sum function in a Formula Field has a error.It says:

No overload for method 'Sum' takes 1 arguments

My Formula is:

Code: Select all

SumD(SqlDataSource1.SumR)* SqlDataSource1.ValueSeasonRatio

please help me.

Breeze · Post by **Breeze** » Thu Apr 05, 2012 2:15 am

You can try like this
SumD(SqlDataSource1，SumR)* SqlDataSource1.ValueSeasonRatio

galawij wrote:Hello,
how can I Multiply two fields in a Formula Field that one of fields is a sum of columns.
when I use sum function in a Formula Field has a error.It says:
No overload for method 'Sum' takes 1 arguments
My Formula is:
Code: Select all
SumD(SqlDataSource1.SumR)* SqlDataSource1.ValueSeasonRatio
please help me.

galawij · Post by **galawij** » Thu Apr 05, 2012 3:18 am

I Find It:

Code: Select all

(decimal)SumD(GroupHeaderBand2,SqlDataSource1.SumR)*SqlDataSource1.ValueSeasonRatio

:byebye: :biggrin: :grinder:

Breeze · Post by **Breeze** » Thu Apr 05, 2012 3:38 am

YEAH THAT IS RIGHT !!!I KNOW WHAT YOU WANT!!

galawij wrote:I Find It:
Code: Select all
(decimal)SumD(GroupHeaderBand2,SqlDataSource1.SumR)*SqlDataSource1.ValueSeasonRatio
:byebye: :biggrin: :grinder:

Post by **Ivan** » Mon Apr 23, 2012 4:10 am

Hello,

We are always glad to help you.
Let us know if you need any additional help.

Thank you.