4 Replies Latest reply: Feb 23, 2014 1:45 PM by AVIRAL NAG RSS

    Object Calendar Julian date in pivot table

    Claudio Degli Antoni


      Hi all,

      Probably it is an easy question but I tried with hundred expressions without solve the problem.

      I create  an expression (pivot table) with format date "YYYYMMDD" the pivot works pefectly,

      Instead if I use the Julian date the expression doesn't work.

       

      =sum({<JulianDate = {'>=$(vDataJFrom)<=$(vDataJTo)'}>} [Day]

      Hire attached an example

       

      Anyone knows  the solution ?

      Many Thanks

      Claudio