Give this a try:
IF [Category] = 'Furniture' THEN [Sales]*1.25
ELSEIF [Category] = 'Office Supplies' THEN [Sales]*1.5
ELSEIF [Category] = 'Technology' THEN [Sales]*2 END
You're off to a good start, and using the right type of logic, but those are three separate statements providing 3 different answers all at the same time.
You just need to use an ELSEIF to transition to the next contingent statement. If it's one thing or another, you could also just use ELSE.
Hope that helps!
Many thanks for your help! It worked perfectly.
I find tableau to be quite challenging as I do not have any SQL knowledge and have not written a lot of formulas. All of this is still quite intimidating, but help from the community is giving me hope! :-)
It works! Thank you so much! The answer was much simpler than expected.