Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LEFT JOIN
REASONS:
LOAD STANDARD_REASONS
FROM
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
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