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

    Set Identifire

    Treasure Dlamini

      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)"}>}
      Amount)),0,31))*-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

                rangesum(

                         above(

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

                                      StrikeReturnPartial={Strike},

                                      Month={"<=$(=Max({<Year={$(=Max(Year))}>}Month))>$(=Max({<Year={$(=Max(Year))}>}Month)-1)"}

                                     >}

                                   Amount),

                               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.

             

            Peeter

            • Re: Set Identifire
              Treasure Dlamini

              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,