We help IT Professionals succeed at work.

Report - Add "My Group"

pdvsa
pdvsa asked
on
Experts, I have a report and I need to add a “My Group” to this report in the query developer.


If [DateSentToBank] is not null and [DateOfIssueSB] is null then “Pending”
If [DateOfIssueSB] is NOT null then “Issued”
So, if at anytime, [DateOfIssueSB] is not null then its "Issued" but if [DateOfIssueSB] is null and [DateSentToBank] is not null then "Pending"

The below is not correct but It would look something like this:
MyGroup: IIf(Nz([DateSentToBank],"") and notisnull([DateOfIssueSB]) "Issued","Pending"))
I dont think I can use notisnull like I am doing.

I might be going about it the wrong way, open to any new suggestions how to do this.  


Thank you
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:

It could be:


 MyGroup: IIf([DateOfIssueSB] Is Not Null, "Issued", IIf([DateSentToBank] Is Not Null, "Pending"))
pdvsaProject finance

Author

Commented:

Hi Gustav,


Nice. That works great!  Thank you much...

CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:

You are welcome!

CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:

Please mark as answered to close the question.