Simple formula using startswith operator

[runnerlk]

Hi trying to create a simple formula that is applied based on certain group membership. Datasource is a .csv file.

If memeber of group then apply formula otherwise ignore.

Here is code so far:

if {ReportExport_csv.cGroupName} StartsWith 'agent' then {ReportExport_csv.cBWPages} - 800 else {ReportExport_csv.cBWPages} = {ReportExport_csv.cBWPages} *1

When it runs if group starts with agent the formula works but for all others i get a '0'.

Any help would be greatly appreciated.

Lou

 

[Turkbear]

Hi,
Not sure I undeerstand why the multiplication by 1 since that will not change the number, so try:

if {ReportExport_csv.cGroupName} StartsWith 'agent' then ({ReportExport_csv.cBWPages} - 800)
else
{ReportExport_csv.cBWPages}



To Paraphrase:"The Help you get is proportional to the Help you give.."