Page 1 of 1

Sum in Formula Fields

Posted: Thu Apr 05, 2012 12:35 am
by galawij
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.

Sum in Formula Fields

Posted: Thu Apr 05, 2012 2:15 am
by Breeze
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.

Sum in Formula Fields

Posted: Thu Apr 05, 2012 3:18 am
by galawij
I Find It:

Code: Select all

(decimal)SumD(GroupHeaderBand2,SqlDataSource1.SumR)*SqlDataSource1.ValueSeasonRatio
:byebye: :biggrin: :grinder:

Sum in Formula Fields

Posted: Thu Apr 05, 2012 3:38 am
by Breeze
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:

Sum in Formula Fields

Posted: Mon Apr 23, 2012 4:10 am
by Ivan
Hello,

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

Thank you.