3 Replies Latest reply: May 30, 2016 7:28 AM by Treasure Dlamini RSS

    Set Identifire

      Hi Guys,


      please help, what does the below statement mean :


      if(DAY<DAY(Today()),rangesum (above((sum({$<Year = {$(=max(Year))},StrikeReturnPartial= {Strike}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"}>}


      Many thanks,

      Treasure Dlamini

        • Re: Set Identifire
          Sunny Talwar

          Expression seems to be accumulating Amount for days up-until the Today()'s day for each month

          • Re: Set Identifire
            Peter Cammaert

            Taken out of context, this is damn difficult to explain. The expression refers to at most 31 previous cells in a chart/table so Sunny is probably right. Also, in each separate month, it will not pass the current day number, so its a "DayToDate" accumulation, if you can call it that way.


            Can you post a screenshot with the chart dimensions?


            Entering an expression like this in the expression editor and adding whitespace makes it a lot more readable. Like so:


            if (DAY < Day(Today()), // Only for daynumbers smaller than today's day number



                               sum({$<Year={$(=max(Year))}, // max selected year, max month in that year





                               0, 31) // Go back max 31 days

                        ) * -1, // Invert

                '' // Display nothing for days >= today's day number



            AFAIK it may do weird things in January.



            • Re: Set Identifire

              Hi Peter/Sunny


              Thanks guys, I see what you mean here, Peter please see below screenshots,


              I now see the numbers are accumulating, but I still don't know what does the expression min,