I have a A/R Aging Reports run by Details and Summary and I used this formula to exstract the invoice amount that greater than 120 days so I can place it in the column >120Days.

It works for the A/R Aging Details report but it didn't work out for the A/R Aging Summary reports. It would grab all the number in the D_90 string it suppose to pick out the invoice amount that meet the condition.

Here is the formula.
if date(year(today()),month(today()),day(today()))>120 + {V_BI_AR_AGING.INV_DATE} then {V_BI_AR_AGING.D_90}

Any help would be great.!

Thanks in advance