Subtract Null - Value

[#1]

Hi

I have a scenario , whre i have to subtract the null value with the value.

Pls find the attached file...

Thanks

[its_anandrjs]

Now check i forget some thing before

Try this way in expression

=Sum( if( len(A) = 0,0,A)  - B)

=Sum(B - if( len(A) = 0,0,A) )

[amit_saini]

Senthil,

Please see the attachment.

Thanks,

AS

[hic · Accepted solution]

For arithmetic operations on NULL values, you should always use the Range functions. Hence, to calculate the difference between two fields, you should use:

     Sum( RangeSum( A, -B ) )

A conditional expression like e.g. If(IsNull( A ), .... ) will always take longer time to evaluate.

HIC

[SunilChauhan]

Sum( if( isnull(A) ,0,A)  - sum(B)

[#6]

Hi,

Hope you are looking for the below result.

Please check the attched file for the same.