0 Replies Latest reply: Jun 15, 2011 4:48 PM by Donald Posthuma RSS

    Problem set analysis using QuarterStart

    Donald Posthuma

      For an application I want to show data from the currently selected quarter and from previous quarters based on the selection. I've create a field StartQuarter within the master Calendar which hold the juliandate for the start of the Quarter. Now I use the set analysis displayed below.

       

      Current month:

       

      =SUM({$<StartQuarter = {$(=QuarterStart(StartQuarter,0)*1)}>}SumSales)

       

      Previous Month:

       

      =SUM({$<StartQuarter = {$(=QuarterStart(StartQuarter,-1)*1)}>}SumSales)

       

      I know that for the first expression the set analysis is unnecessary but I did this for uniformity. The problem with the expression is that it won't display the value when I use -1 instead of 0 for the QuarterStart command. I checked the output from the QuarterStart outside the set analysis and it does return the correct JulianDate however it won't work in the set analysis. Any suggestions?