Skip to Content
0
Former Member
May 12, 2014 at 09:00 AM

formula help please

21 Views

Hi All,

I have a report where I have two fields completed by and quarterly_review.For Q2 I have corresponding value for Quarterly_review columns as Approved(as below)

I kept four hard coded values q1,q2,q3,q4 in my report header section.

So whenever review happened or having a value(quarterly_review field) for the particular quarter I need to show the respected values for that.

otherwise it has to show the empty value.

I think we have to create a formula please suggest how to do

Attachments

DB.png (131.9 kB)
Untitled.png (159.8 kB)