The TOTABLE() function is meant to be used with functions that do not support table-mirroring out of the box. With the SI.QUERY function, you can simply use the OutputColumn argument to specify the location of the first column of the table. You are then completely free to rename the column header, and Velixo will be smart enough to remember where the data goes when refreshing.
Question: do you have a filter setup on your query? Aggregation happens locally at the moment so the full GLDETAIL will be loaded without any filtering.
P.S. I moved your post to the Sage Intacct area.
0 Votes
B
Ben Perryposted
about 23 hours ago
Oops this was meant to be posted in the Sage Intacct Ideas section. Dunno if it can be moved?
0 Votes
Howdy,
I'd love to be able to specify a custom column name when using Aggregate functions.
I'm using TOTABLE with SI.QUERY and when referencing a column in the table it's something like this:
It would look a little nicer to have something like this instead:
I imagine the syntax could be similar to SQL column aliases:
SI.QUERY("Sage","GLDETAIL",,"LOCATIONID,DEPARTMENTID,ITEMID,SUM(AMOUNT) As TOTAL")Hopefully that makes sense.
Cheers
Ben
0 Votes
3 Comments
Gabriel Michaud posted about 19 hours ago
I forgot to attach the file I built in the video - here you go!
Attachments (1)
Query with T....xlsx
19.8 KB
0 Votes
Gabriel Michaud posted about 19 hours ago
Hi Ben,
The TOTABLE() function is meant to be used with functions that do not support table-mirroring out of the box. With the SI.QUERY function, you can simply use the OutputColumn argument to specify the location of the first column of the table. You are then completely free to rename the column header, and Velixo will be smart enough to remember where the data goes when refreshing.
Here's a short video demo: https://www.loom.com/share/4737c79e994b4c53b40797c20f560e26
Question: do you have a filter setup on your query? Aggregation happens locally at the moment so the full GLDETAIL will be loaded without any filtering.
P.S. I moved your post to the Sage Intacct area.
0 Votes
Ben Perry posted about 23 hours ago
Oops this was meant to be posted in the Sage Intacct Ideas section. Dunno if it can be moved?
0 Votes
Login or Sign up to post a comment