Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
How can i right the expression when i need to show sum of sale when LogedDate is null and Recieved Date is null.
thanks
Try this
if(isnull(LogedDate ) and isnull([Recieved Date]),Sum(Sales))
Try this
if(isnull(LogedDate ) and isnull([Recieved Date]),Sum(Sales))
You can create back end flags for null dates.
If(IsNull(LoggedDate) or Len(Trim(LoggedDate))=0, 1) as Flag_LoggedDate,
If(IsNull(ReceivedDate) or Len(Trim(ReceivedDate))=0, 1) as Flag_ReceivedDate
now use
=SUM({<Flag_LoggedDate = {1}, Flag_ReceivedDate = {1}>}Sales)
Or without creating flags...
=SUM(IF(IsNull(LoggedDate) and IsNull(ReceivedDate),Sales))
or
=SUM(Sales)-SUM({<LoggedDate = {"*"}>+<ReceivedDate = {"*"}>}Sales)
or
=SUM({1}Sales)-SUM({1<LoggedDate = {"*"}>+1<ReceivedDate = {"*"}>}Sales)