9 Replies Latest reply on Feb 21, 2019 10:16 AM by bhargavi chittibomma

    10th business day should show current month data

    bhargavi chittibomma

      Hi All,


      I have the below requirement


      My revenue data would be calculated end of every month and that would be populated to our datasheets every 8th business day of each month. So If its 8th business day tableau should automatically calculate and show current month data, if not should show previous month data.

      The below is the logic i am using to show just previous month data. But don't know how to calcuate the 8th business day current month data logic.


      IF DATEDIFF('month',[Revenue Year],TODAY())=1 then [REVN_AMT] END


      can any one help me in modifying the logic to show what i need,,


      Instant help on this would be appreciated