Sql Calculation Question

[eetimm]

I am trying to make a SQL calculation in a HTML data page, to display the sum of points attained by the logged-in group member. 

 

My SQL statement, in a calculated field, is:

 

select
sum(Points)
from Activity_Table
where Activity_Table.Member_ID = [@field:Member_ID]

 

If I manually set the member_ID field in the formula (e.g. Activity_Table.Member_ID = 103), the formula works correctly, but when I try it as shown above my result is the sum of ALL points regardless of member.  I am assuming that there is some problem passing the field value correctly, but I can't figure it out.  Anyone have any thoughts?  Thanks!!

[eetimm]

Finally got this to work...

 

I used [@authfield:Member_ID] to get the ID of the logged-in user and that worked. 

 

It is always something....

[MayMusic]

Where do you want to have this formula? Details or report? Is it aggregation or calculated field? You do not need to include the member ID since for each record system can recognize the ID. In aggregation you can use the field name to refer to it with not [@field:   ]

 

So you can refer to it in this format where Activity_Table.Member_ID = Member_ID

[eetimm]

Thanks for the response....I was afraid that my question was not that clear....

 

I am using this formula in a HTML data page, and it is in a calculated field.  I can get the field to calculate correctly when actually put the Member_ID in the formula, but when I try to reference the field the calculation returns the total of all members. 

 

I tried your suggestion of directly using the field in the formula (replacing [@field:Member_ID] with just Member_ID) but this had the same result.

 

I will keep trying alternatives.

 

Thanks for your help.