Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have downloaded the qsVariable extension and have my buttons created for 'Top 10' and 'Bottom 10'. I also have a variable named 'vTopBot' with the value 2 in it so that it is linking to the 2 buttons (1 for Top 10 and 2 for Bottom 10).
In order to get my top 10 and bottom 10 my syntax is as follows:
top 10:
SUM({<$vTopBot= {"=1, (SUM(invoiceTotal),)<=10"}>}invoiceTotal)
bottom 10:
SUM({<$vTopBot= {"=1, (-SUM(invoiceTotal),)<=10"}>}invoiceTotal)
I am positive syntax is off because I am unable to display any data. Any thoughts or insights would be greatly appreciated. Thanks.
Thank you. My issue is when using the extension for the variable set up I am only prompted with picking only one variable. It seems that I need to set up 2 variables for the top and bot 10. I have attached a png.
I completely understand your syntax. Thanks for that. The issue I am seeing is when I have my extension it only takes in one variable. Is there a way to dynamically let my variable 'vTopBot' know its top 10 and bot 10? Or am I forced to create 2 separate variables and buttons to accommodate this?