Summary of Shortcut field in a Query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Summary of Shortcut field in a Query

Post by 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?
Tom - V8.8 build 3137 - MySql / PostGres
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Summary of Shortcut field in a Query

Post by 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
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Summary of Shortcut field in a Query

Post by tford »

Mark,

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

Tom
Tom - V8.8 build 3137 - MySql / PostGres
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Summary of Shortcut field in a Query

Post by customaware »

single quotes around the format from #,### to '#,###'
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Summary of Shortcut field in a Query

Post by 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.
Tom - V8.8 build 3137 - MySql / PostGres
Post Reply