Calculation based on Booked date days

Question

Hello Team,

Require calculation for the attached file for the below criteria:

If Type numbers = "Yes" Then "Yes"

ELSEIF TODAY()-BOOKED DATE <90 THEN TYPE NUMBERS = "No"

ELSEIF TODAY()-BOOKED DATE >90 THEN TYPE NUMBERS = "BOTH"

END

but getting error in calculation.

Need help to get this done correct. I have attached sample file.

Regards

Jim Dehner - Tableau Visionary HoF · Accepted Answer

your data are text values and not dates - date functions can only be used with real dates - to convert your string to dats see See it your way: FAQ Series - Convert String Dates (jimdehner2.blogspot.com)

Jim

Tableau Community Forums Member (Inactive) · Answer

Hi, Ashish Please find my explain and comment in below screenshot. Basically the error is because your expression is trying to return different data type from if-else statement. so to avoid that, you need keep the same data type in your if-else statement Hope this helps ZZ

Calculation based on Booked date days

Tableau Desktop & Web Authoring

Related Learning

More Help