Formula containing two conditions and null values

[stixmike]

Hi,

This is a question about creating a calculated formula in Tableau from a flat file Excel spreadsheet. I'm not sure if you guys can help, but here it goes:

I have an Excel file with 10 data sets that are duplicated 5 times each to account for the data set passing through five different stages in a value stream. Each data set lists a date when it passes through a stage.

I need a formula where if a cell in column C is empty and a cell in column B is NOT empty then it will calculate the number of days difference between today's date minus the date in cell B.

Can anyone help?

[mcmahobt]

Assuming your data starts in C1 and B1, and that your formulas coincide on the same row, try this:

Please Login or Register  to view this content.

[stixmike]

Hmm, that seems like it should work, but Tableau says "cannot compare date and string values". Maybe because of the ""?

[mcmahobt]

Are your excel values in column B stored as text? Try this:

Please Login or Register  to view this content.

[stixmike]

Still receiving the same error. I used this:

IF([Transaction Date]="" AND [Start Date]<>"") THEN TODAY()-DATE([Start Date]) END

Transaction Date and Start Date are the fields.

[mcmahobt]

If you're using Excel, this is not the right syntax. Using your fields, it should be"

Please Login or Register  to view this content.

If that doesn't work you may want to provide a sample workbook.