Expression logic

[smilingjohn]

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

[shiveshsingh · Accepted solution]

Try this

if(isnull(LogedDate ) and isnull([Recieved Date]),Sum(Sales))

[MK_QSL]

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))

[MK_QSL]

or

=SUM(Sales)-SUM({<LoggedDate = {"*"}>+<ReceivedDate = {"*"}>}Sales)

or

=SUM({1}Sales)-SUM({1<LoggedDate = {"*"}>+1<ReceivedDate = {"*"}>}Sales)