Sql Error

[theconav]

Hello all,

 

I ve been trying to solve this issue for quite so e time now:

 

Field : FieldOne --> Text

Fied  : FieldTwo --> Number

 

Field : Ttl --> Calculated

 

I have the following SQL in the calculated field:

 

SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = '[@field:FieldOne]'

 

However I do not get nay results.

 

I have tried also the following alternative

 

SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = [@field:FieldOne]

 

This gives me the sum of FieldTwo, however ignoring the criteria set by the WHERE.

 

If I try SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = 'XXX' (i.e. passing a specific value instead of whatever value [@field:FieldOne] carries), then it works fine. 

 

Could someone help please ?

 

Thank you

 

[JoennAquilino]

Hello,

Try adding IsNull on the field inside the Sum.

SELECT Sum(IsNull(FieldTwo,0)) From tTable_Name WHERE tTable_Name_Field = '[@field:FieldOne]'

 

EDIT: I didn't noticed the date. I reported this post. Sorry. I saw this thread at the top where the unanswered threads are located.

[DefinitelyNot31337]

Hi @theconav,

 

Please try adding the target keyword in your calculation. The target keyword means that you refer to the current row in your table.

Documentation located here.

 

The result should look like this:

SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = target.[@field:FieldOne]