5 Replies Latest reply: Aug 1, 2012 7:00 PM by Amien Amien RSS

    Problem in Expression SUM

    Sudip Sen

      Hi,

       

      I have the following straight table. The Selection column is a calculated expression and Prejected losses is having the same value as Selection, the only difference is, the values are Accumulated.

       

      My issue is, when I am deriving the next column i.e. Stat asEX, the calculation should be, (Max value of Projected Exposure) - each row of Projected Exposure. I have tried to use SUM(Selection) to get the Max value of projected exposure, but always get 0.

       

      Chart.bmp

       

      Can somebody please help me to resolve this issue.

       

      Thanks,

       

      Sudip Sen

        • Re: Problem in Expression SUM
          Celambarasan Adhimulam

          Try like this

          $(=Selection expression)-[Projected Exposure]

            • Re: Problem in Expression SUM
              Sudip Sen

              Hi,

               

              Thanks for your reply. I have tried the solution you suggested, but the answer is not coming as expected.

               

              Chart 1.bmp

               

              The values should come as given below:

               

              Selection              Projected           Stat asEX
                Losses

              14,000,943            14,000,943           3,031,756       Logic - 17,032,699 - 14,000,943
              840,668                14,841,611           2,191,088       Logic - 17,032,699 - 14,841,611
              863,750                15,705,361           1,327,338       Logic - 17,032,699 - 15,705,361
              300,726                16,066,087           966,612          Logic - 17,032,699 - 16,066,087
              393,300                16,399,386           633,313          Logic - 17,032,699 - 16,399,386
              245,670                16,645,057           387,642          Logic - 17,032,699 - 16,645,057
              275,179                16,920,236           112,463          Logic - 17,032,699 - 16,920,236
              112,463                17,032,699           0                    Logic - 17,032,699 - 17,032,699

               

              Thanks,

               

              Sudip

              • Re: Problem in Expression SUM
                Celambarasan Adhimulam

                What expression you are used  for Selection?