I'm struggling with the syntax to make it behave like this msSQL does:

 

I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals....

--sd

Edited August 7, 20241 yr by Søren Dyhr

This is not a good way to ask a question. 

First, I don't know how MS SQL behaves. Next, I don't know what exactly "too many ?'s" means. If you are constructing the SQL in the Data Viewer, you should be getting a (more or less) helpful error message. As it is, it's not clear neither what the problem is nor the expected solution. It would be much better to post a file with sample data alongside the exact result you expect to get from it.

I can only guess you are after something like the attached example.

SubGroupSQL.fmp12

 

4 hours ago, Søren Dyhr said:

I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals....

The best way to do this is to use the "Fast Summaries" method. 

 

Edited August 7, 20241 yr by comment

1 hour ago, comment said:

I can only guess you are after something like the attached example.

It was exactly what I was after ... thank you!

--sd