Hi Sameer,

can you share the sample data shown in the screenshot? It would be easier to do it then discuss.

Thanks and Regards,

Ashish Chaudhari

HI Sameer

 

I want to check if current date -1 = calday and fiscal month = current mont and fiscalday <= currntday then sales

In Tableau we have the TODAY() function which can be used.

So for yesterday its simply TODAY()-1

And in a logical test -

IF [calcday] = TODAY()-1 THEN TRUE ELSE FALSE END

We can then extend that...

IF [calcday] = TODAY()-1 AND MONTH(TODAY()) = [fiscal month] AND [fiscalday] <= TODAY() THEN [sales] ELSE NULL END

Important - you need to make sure these fields are dates - they should have a little calendar icon.

I hope the above is clear, it may not be perfect but I can help you with specifics...

Cheers

Mark

Edited to finish extended IF calc.

Hi Sameer

Right idea, but you need to provide a packaged workbook

File - Export packaged workbook

We want one with a twbx file extension, otherwise we dont have any data.

Cheers

Mark

I want to check if current date -1 = calday and fiscal month = current mont and fiscalday <= currntday then sales

This works fine -

IF TODAY()-1 = [Calday] THEN [Sales] END

The problem -

fiscal month = current mont

fiscal month for 'nowday' is 2

but month of July is 7           2 <> 7

fiscalday <= currntday then sales

fiscal day for nowday is 6

but day of current day is 5 (calcday = 4)      6 is greater than 5 (or 4), not less, this will also fail

Not sure where / how to help?!