Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a table with ProductId and respective sales.Requirement is to sum(Sales) where productId is null.I have write following condition but it didnt work please if anyone has any idea please share with me.
Syntax
Sum({<ProductId={-}>}Sales)
I know,I have missed something but I didnt get what it is.
Table is in following snapshot
Try
Sum({<ProductId-={'*'}>}Sales)
or
Sum({<ProductId={"=IsNull(ProductId)"}>}Sales)
Thanks
Bhawna,
Try this:
sum( if(isnull(ProductId), Sales))
Thanks,
AS
Method-1
In Script
NULLASVALUE ProductID,Sales...
Set NullValue = 'PN' ;
Load ProductID,Sales from Sales_Tab;
In Expression: Sum({<ProductID={'PN'}>}Sales)
Method-2
sum( if(isnull(ProductId), Sales))