I have a requirement to provide the amount tickets need to reach a goal (85%). To get a better understanding I am doing this in excel but will end up being converted to Tableau's custom formula. I would expect to see a result of 5 as it should be rounded to a whole number. Any idea how I would go about writing this?
Here are the data inputs:
Vendor Closed Total tickets Current % Target % Tickets need to hit Target
Joe's shop 22 31 70.97% 85.00% ?