Summary of Shortcut field in a Query

tford

I have a shortcut attribute in a Sales_by_School query that I need to put in the Summary line of the query.

The attribute is: Sales_by_School.Nbr_CMs_sc
Shortcut path: School.Nbr_CMs

I've tried:
<<SUM Sales_by_School.Nbr_CMs_sc@#,###>> ---> this returns 0
<<SUM Sales_by_School.School.Nbr_CMs@#,###>> ---> this just puts some of the text from the formula in the summary area

Any ideas?

customaware

Try....

<<SUM Sales_by_School.Nbr_CMs_sc@'#,###'>> ---> this returns 0
<<SUM Sales_by_School.School.Nbr_CMs@'#,###'>> ---> this just puts some of the text from the formula in the summary area

tford

Mark,

Didn't you just repeat what I said I tried?

Tom

customaware

single quotes around the format from #,### to '#,###'

tford

Oops. Sorry about that.

<<SUM Sales_by_School.Nbr_CMs_sc@'#,###'>> returned the correct value when the query is un-filtered, but not when it's filtered.

The 2nd one didn't return a value.

So, I resorted to adding School.Nbr_CMs_CALC and added a rule to calc that field instead pulling it in via shortcut.

I guess the fact that the shortcut has two .'s in it causes the issue with the aggregate function.