8 Replies Latest reply on Apr 26, 2016 10:47 AM by ChandraSheker A

    Creating Dates which don't exist

    ChandraSheker A

      Hi all,

      i have a small requirement. and my data looks like this below.

       

      which is Data of funded on left and Number of Funded customers(count of ID) on right column.

       

      My business generally funds on most of the business days, But not on weekends.

      I may not be able to fund on some business days as well. So i wanted to see above Data column with those dates.

      in above: 3/14/16 is a business day since i dont fund any i wanted to see that date in above table and count as 0.

      Similarly with all weekends.

      i wanted to those dates.

       

      How can i create a calculated field on this.

       

      Thanks.