Expression

[upaliwije]

Hi,

sum(IF(DESCRIPTION='NET_PROFIT')<0,{<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)

my above expression does work. Pls help me to correct it

[sunny_talwar]

May be this:

=Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)

[puttemans]

What exactly do you want to realize? Seems like you're mixing up bracket types and syntax.

[upaliwije]

Tks

What Exactly I want to get is If Description='NET_PROFIT'<0  then sum Actual where Description='NET_PROFIT'

[sunny_talwar]

Try this may be:

=Sum({<DESCRIPTION={"=NET_PROFIT<0"}>}ACTUAL)

[puttemans]

This is a bit strange. What is the name of you variable? Description or net_profit?

If net_profit and Actual are variables, then the formula should look like :

sum( If( NET_PROFIT < 0, Actual, 0))

If your variable is Description, then how can NET_PROFIT be a variable together with '0'?

[upaliwije]

It also does not work

[sasiparupudi1 · Accepted solution]

This May be

if (Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)<0,Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL),0)

[krishna20]

Hi,

This may be

If(DESCRIPTION='NET_PROFIT'<0,SUM({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL))

[NavinReddy]

try like this

If(DESCRIPTION='NET_PROFIT'<0,SUM({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL),0)