How to subtract sales tax from certain rows for sales revenue dashboard?

I'm not sure of the best way to go about solving this, so I'll do my best to describe my issue below. Any assistance would be appreciated.
I'm trying to create a pie chart showing total sales YTD and breaking it down by rep. I have it mostly made but my numbers are a little high. I looked at my dataset and my TotalPrice column is including sales tax on orders that are fulfilled, but not including sales tax on orders that are open.
Titles and descriptions for the columns I'm using for this card are below:
TotalPrice - The total cost of the sales order
SalesRep - Name of sales rep
StatusId - Gives status of the order (20=Open, 60=Fulfilled, 85=Cancelled, etc)
EstimatedTax - Gives the total sales tax of the sales order
I need to figure out a way to subtract the sales tax from the total price, IF the status of the order is fulfilled.
Best Answer
-
Hi Leon,
You would create a new beastmode using the following:
CASE WHEN `StatusId` = 60 THEN `TotalPrice` - `EstimatedTax` ELSE `TotalPrice` ENDHere is a reference for questions around Beast Modes:
If I solved your problem, please select "yes" above
1
Answers
-
Hi Leon,
You would create a new beastmode using the following:
CASE WHEN `StatusId` = 60 THEN `TotalPrice` - `EstimatedTax` ELSE `TotalPrice` ENDHere is a reference for questions around Beast Modes:
If I solved your problem, please select "yes" above
1
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive