Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to seperate several formulas data with similar conditions?

Hi,

I have 3 formulas in the group footer where each row refers to each record.

Each row should show 0  0   1  or 1   0   0   or 0  1   0 but since some conditions are the same or the returned data is not accurate.

Is there a way to distinguish between formulas instead of adding more conditions to each formula?

IF ISNULL({END_DATE.date_value}) then '1' 

ELSE IF currentdate > {END_DATE.date_value} and Year({END_DATE.date_value}) = year(currentdate) then '1' 

ELSE '0'

IF ISNULL({END_DATE.date_value}) then '1' 

ELSE IF currentdate >= {START_DATE.date_value} and Year({START_DATE.date_value}) = year(currentdate) and currentdate <= {START_DATE.date_value} then '1' 

ELSE '0'

IF ISNULL({START_DATE.date_value}) then '1' 

ELSE IF currentdate < {START_DATE.date_value} and Year({START_DATE.date_value}) = year(currentdate) then '1' 

ELSE '0'

Regards,

B.

Former Member
Not what you were looking for? View more on this topic or Ask a question