lbass -
{@days}:
if {@datediff}<30 then totext("Current") else
if {@datediff}>=30 and {@datediff}<60 then totext("30 Days") else if {@datediff}>=60 and {@datediff}<90 then totext("60 Days") else if {@datediff}>=90 and {@datediff}<120 then totext("90 Days") else if {@datediff}>=120 then...
synapsevampire - Sorry, new at this.
{@NOT Specified} is just a group name formula I'm using:
if isnull({ReportsStatic.brokername}) or
{ReportsStatic.brokername}="" then " *Not Specified" else
{ReportsStatic.brokername} + " " +"-" + " " + {ReportsStatic.correspondentbrokercode}
and same...
I do a group sort by a formula. The formula is not available to sort by.
The report has 2 groups. I am summarizing the data in group 1 then calculating a percentage.
Formula 1 DELQ (supressed in detail)
if {@groupDelqCode}="30 Days" or
{@groupDelqCode}="60 Days" or
{@groupDelqCode}="90 Days"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.