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

# Problem in Expression SUM

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.

Thanks,

Sudip Sen

• ###### Re: Problem in Expression SUM

Try like this

\$(=Selection expression)-[Projected Exposure]

• ###### Re: Problem in Expression SUM

Hi,

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

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

What expression you are used  for Selection?

• ###### Re: Problem in Expression SUM

Its a calculated field and the formula is :

if(isnull(Column(2)*Column(4)),0,Column(2)*Column(4))

+

if(isnull(Column(3)*Column(5)),0,Column(3)*Column(5))