Two formuals issue

Mon, 04 Nov 2013 15:04:17 GMT

HI guys,

I have an expression

Sum (if (TxnType<>'Estimate' and TxnType<>'Sales Order',Amount,0))

This works

But i need to do add something more to do it.

I need to add

If (TxnType = 'Credit', Amount*-1, Amount) to this same expression.

so basically i need is

SUM

(

while (rowcount)

{

if (TxnType<>'Estimate' and TxnType<>'Sales Order') Then

Amount = Amount;

else

Amount = 0;

If (TxnType = 'Credit') Then

Amount = Amount * -1;

else

Amount;

}

)

Can you please tell me how to do that.

Thanks,

Saurabh

Re: Two formuals issue

swuehl — Mon, 04 Nov 2013 15:08:48 GMT

Try

Sum (if (TxnType<>'Estimate' and TxnType<>'Sales Order',

if(TxnType = 'Credit',-Amount,Amount)

, 0)

)

Mon, 04 Nov 2013 15:29:34 GMT

It is working.

Thanks!