Sql Question

[Elena]

Hi Jan or May Music,

 

In the details page of the report table, I am trying to sum up the values of fields that are both direct fields and calculated fields. It's returning me the "Error in formula" message.

 

I am missing something (I'm not even sure if calculated fields can be summed up like this), can you please let me know what it is?

 

Below is the code:

 

SELECT
SUM([@calcfield:1])
+ SUM([@field:Experience_Min])
+ SUM([@field:Education_Min])
+ SUM([@field:ConsequencesErrorsNew])
+ SUM([@field:Education_Min] )
+ SUM([@field:Work_Delegation])

+ SUM([@calcfield:29] )
+ SUM([@calcfield:28] )
+ SUM( [@calcfield:36] ))
FROM SJECS where [@field:Last_Name]>[@LName]

 

All values are in number format.

 

[iren]

Hello Elena,

 

You can use following code in the calculate field:

SELECT SUM([@calcfield:1]+[@field:Experience_Min]+[@field:Education_Min]+[@field:ConsequencesErrorsNew]+[@field:Work_Delegation]+[@calcfield:29]+[@calcfield:28]+[@calcfield:36]) FROM SJECS WHERE [@field:Last_Name]>[@LName]

 

Hope it helps.

[Elena]

Hi Iren, good mornig, let me do that now, will get back in a few.

[Elena]

Thought, I'd report back. The code recommended didn't work either.

[iren]

Hi Elena,

 

Tell me please, the code does not work or 'Error' message still appears?

[Elena]

Hi again Iren,

 

The code still gives me 'Error in Formula' message.

[greyfoundation]

Hi Elena,

Thought I note in case it is the logic behind the formula, could it be that field calcfield 29 is trying to be calc before calcfield 28.

Don't know if this may cause an issue cheers paul

[Jan]

Hello Elena,

 

As far as I know, "Select" takes the data from table "SJECS", but values of calculated fields are not saved in the table.

 

Maybe, you can add this calculated fields to your table? I mean, add fields and enter values for every record.