Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a scenario , whre i have to subtract the null value with the value.
Pls find the attached file...
Thanks
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
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) )
Senthil,
Please see the attachment.
Thanks,
AS
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
Sum( if( isnull(A) ,0,A) - sum(B)
Hi,
Hope you are looking for the below result.
Please check the attched file for the same.