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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive