I have a scenario , whre i have to subtract the null value with the value.
Pls find the attached file...
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) )
Please see the attachment.
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.
Sum( if( isnull(A) ,0,A) - sum(B)
Hope you are looking for the below result.
Please check the attched file for the same.
Retrieving data ...