Can I get some help on Tableau? When I create a new field for Turnover, what formula do i put?

Exercise 3 - Obsolete Inventory Evaluation To address inventory valuation and possible obsolescence, you decide to calculate inventory turnover rates. Since USAGE is the annual use of the inventory items, we can get an indication of the relative amount of inventory on hand by dividing USAGE by QTY (USAGE / QTY) Review the information below about how inventory obsolescence is determined. A turnover rate of 1.00 may be viewed as indicating that the inventory takes a year to sell (turn over), or equivalently, that the company has a 1 year supply of the goods on hand. A turnover rate of 2.00 would be a 182.5 day supply. Numbers less than 1 indicate more than a years supply on hand. The following summarizes example turnover rates and supply levels: < .25 Currently, there is more than a 4 year supply in inventory. .25 4 year supply. .50 2 year supply. 1.00 1 year supply. 2.00 year supply >2.00 less than year supply. Thus, the items with low turnover accounts are of concern relating to whether they will ever be sold.

1. Create a labeled graphic that shows the inventory that should be deemed obsolete compared \ to inventory that is not obsolete based on the information above. (3pts) Hint Create a calculated field named YourName_Turnover which shows the inventory turnover rate using the information provided.

Create a calculated field named (YourName_Obsolete) that identifies inventory that has a turnover rate =< 1 IF [Turnover]>1.0 THEN NULL ELSEIF [Turnover]<=1.0 THEN TRUE