2 Replies Latest reply on Jul 22, 2016 3:37 AM by Somok Sarkar

    Date Calculation and representation

    Somok Sarkar

      Hi All,

       

      I am facing an issue to create 2 calculated fields which needs to be represented in a tabular format.

       

      We have the sales data for for various product ID's. The dates which are missing means that on those dates the sales volume should be 0.

       

      We need to create two calculated field:

      1. Active account : condition should be - (If the total sales for 3 months is higher than 0 then set 1, else 0)

      2. New Account : Condition should be - If the sales in the past month is 0, and there is a sale on the for the first time, then set 1.(even if any first sale on the first month then set 1)

      I am sharing the .twbx file where the data needs to be represented in the below format.

       

      Month DateProduct IDSalesActive accountNew Account
      2014121111111000
      201501111111110011
      2015021111111010
      2015031111111010
      2015041111111000
      201505111111110010
      2015061111111010
      201507111111110010
      201508111111110010
      2015091111111010
      2015101111111010
      2015111111111000
      201512111111110010

       

       

      I a

       

       

      I