8 Replies Latest reply on Feb 15, 2019 9:00 PM by Andres Garcia

    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

       

       

      Thanks

      Bhargavi