When I use below calculation logic,
(case[Scheduled Ship Current Fiscal Week Flag] when 'Y' then
[Scheduled Ship Fiscal Week] end)
I get the expected output as 2021W32.
But when I try to introduce the logical comparison, like below, I get the output as True/False when I expect the actual values to be 2021W33, 2021W34.....
[Scheduled Ship Fiscal Week] >
(case[Scheduled Ship Current Fiscal Week Flag] when 'Y' then
[Scheduled Ship Fiscal Week] end)
Please help! thanks!
7 answers
Here you go! attached both sample data in XL and Tableau workbook.
Please see the tab "Custom Field" on tableau workbook. I created similar custom logic with the dummy data and still I don't see the "past due" value.
Appreciate your help on this!!
