Inclusion of one more criterian in th script

[nevilledhamsiri]

Dear Sunny or any one of our community!

Sunny had proposed the nested if statement as I requested to be written in the script. It worked well. But now I need one more criterian to be included there. That is to includes "Not visited" when person visited, place visited & amended plan equal to zero. I have included it down but seems to be not working. Please help me to add this.

Further I need to have a count of number of countries visited out of proposed plan visit. I need this to be displayed as follows!

How many countries to be visited in a Month?

How Many countries actually visited

The position needs to be shown separately for each Month & total picture when clear the selected Month.

Can this be shown in a text object or in the place to visit list box itself

Thanks

Neville

Date_Plan:

LOAD

[Person to visit],

  [place to visit],

  [Set Date Plan],

  MONTH(   [Set Date Plan]) AS SET_MONTH,

  [Person visited],

  [Place visited],

  [Ammended Dat Plan],

  If([Person to visit] = [Person visited],

     If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_VISIT',

     If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_VISIT',

     If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_VISIT'))),

If([Person to visit] <> [Person visited],

     If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_SUB_VISIT',

     If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_SUB_VISIT',

     If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_SUB_VISIT'))),

     if( [Person visited]=0 ,IF(   [Place visited]=0, IF( [Ammended Dat Plan]=0,

      'NOT_VISITED' ) ))) ) AS TYPE_OF_VISIT

FROM (ooxml, embedded labels, table is Sheet1);

LEFT JOIN

REASONS:

LOAD STANDARD_REASONS

FROM (ooxml, embedded labels, table is Sheet2);

[nevilledhamsiri · Accepted solution]

Dear All,

I was able to add the additional criteria in the script. You may only refer how I may have a counting as I proposed!

Thanks

Neville