20 Replies Latest reply: Feb 26, 2018 11:59 PM by Jonathan Dienst RSS

    Invoice Buckets

    Angel Tomov

      Hello guys, I am trying to create invoice buckets for one of my clients

       

       

      first I define my variable like this :
      let vDate = Date(Today());

       

       

      table:

      LOAD

          Customer,

          InvoiceNo,

          InvoiceDate,

          BookEntryDate,

          TransactionNo,

          Currency,

          "Amount LocCur",

          if('$(vDate)' - Date(InvoiceDate)>='7','7 days',

          if('$(vDate)' - Date(InvoiceDate)>='30','30 days',

          if('$(vDate)' - Date(InvoiceDate)>='90','90 days',

          if('$(vDate)' - Date(InvoiceDate)>='180','180 days',

          if('$(vDate)' - Date(InvoiceDate)>='360','360 days','Not Yet'))))) as Timebuckets

       

      from ....

       

       

      But in the Pivot Chart I made with Customers, I see only Not Yet...


      What am I doing wrong?