2 Replies Latest reply: May 15, 2014 10:13 AM by MonUserCJ _ RSS

    Is there a way to parse the name of a report for a calculated field?

    MonUserCJ _

      Hey all,

       

      I have one report that contains primary insurances and another that contains non-primary insurances. I want there to be a calculated field that is "1" for the rows from the primary insurance report, and "2" for rows from the other report. Is there a way to do this? I would like to use the names of the reports to make this distinction, since there is nothing in the content of the report itself that distinguishes them unfortunately.

       

      Is there some function where I can say "If(InStr("primary", ReportName), 1, 2)" or something like that? I'd appreciate any advice anyone can give.