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?
Summary of Shortcut field in a Query
Summary of Shortcut field in a Query
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 2400
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Summary of Shortcut field in a Query
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
<<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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Summary of Shortcut field in a Query
Mark,
Didn't you just repeat what I said I tried?
Tom
Didn't you just repeat what I said I tried?
Tom
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 2400
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Summary of Shortcut field in a Query
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Summary of Shortcut field in a Query
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.
<<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