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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive