Forum Discussion
KristinBombaci
6 years agoQrew Member
Thank you for your response Austin. I should clarify that I am trying to do this in a report, not in a form so the advice above would not apply. Do have a suggestion on a formula I can use in a report?
------------------------------
Kristin Bombaci
------------------------------
------------------------------
Kristin Bombaci
------------------------------
AustinK
6 years agoQrew Commander
That makes it less confusing with what needs to be shown on the forms. The formula I gave should work for a report as well. You just need to create a new formula field for it.
I can help explain what the formula from my last post is doing in words rather than code.
Basically it is "If [MERRecord - MERS Analyst] is equal to blank, show [PORecord - PO Analyst], otherwise show [MERRecord - MERS Analyst]."
I can help explain what the formula from my last post is doing in words rather than code.
Basically it is "If [MERRecord - MERS Analyst] is equal to blank, show [PORecord - PO Analyst], otherwise show [MERRecord - MERS Analyst]."
- KristinBombaci6 years agoQrew MemberI created the new field and used the formula you provided and it works exactly as I was hoping it would! Thank you for all your help Austin!
------------------------------
Kristin Bombaci
------------------------------