2 Replies Latest reply: Dec 4, 2015 2:17 AM by vikas mahajan RSS

    Using Variables in Fields when creating a Filter

    Christopher McConnell

      I am new to Nprinting and wanted to know if it was possible to have a filter based on a variable?

       

      For example, the document I use has a variable (vLastMonth), and I want to filter a field (Acctg Mon) to whatever the last month was so the report is created only showing the data from the past month. I tried using =vLastMonth and just vLastMonth in the value for the field filter.

      When I brought them into the report and applied them to the image, I was getting an error on my charts that said it couldn't be calculated.

       

      Am I missing some step somewhere in the process of applying a filter with a variable expression, or is this not the right way to go about this.

       

      I read through the article below but couldn't find anything related to this specific problem.

      How to Create Static and Dynamic Filters Based on Fields

       

      Thanks in advance.