GrantSmith Coach 
-
Re: Beast Mode Calculation
Use IN instead of = SUM(CASE WHEN Product Code Number IN ('10','11','12','13','14','15','16','20','21','30','40','50','60','61','70') THEN Quantity ELSE 0) - SUM(CASE WHEN Product Code Number = '83' …1 -
Re: App Studio: Print Button
Because the AppStudio is sandboxed you won't be able to use a button to bring up the print dialog box. You can log an idea in the idea exchange to allow that functionality.1 -
Re: How to add a Toggle button to switch between different currencies at Dashboard Level.
Hi @Ken Have you thought about stacking your data so you have a record in USD and another record in CAD and then use a filter card (radio button?) to allow the user to select a currency amount which …1 -
Re: Count transactions AND sum quantity on specific transactions by type
Are your transactions duplicated? If not you could do a conditional sum like: SUM(CASE WHEN `transaction_type` = 'Quantity' THEN `quantity` ELSE 1 END)3 -
Re: Where is the subtotal chart option? thanks
it should be under Subtotal rows in the chart options to the left of the chart where you can enable the subtotals1
