Community Forums
Community Forums
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
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In
