Conditional statement

[Hi2023]

Hi I need help with correction to my conditional statement.

I need to it make sure it calculates correctly for each catefory and doesnt fall within another category and doesnt have duplicates within results

IF [DG10Count]>1 THEN "DS"+"-"+[Dup_System_10] ELSEIF
[DG9Count]>1 AND [STATUS] IN ("", "Open") THEN "DS"+"-"+[Dup_System_09] ELSEIF [DG8Count]>1 THEN "PS"+"-"+[Dup_System_08] ELSE "NO DUP" ENDIF

I am getting NO DUP for duplicates for DG9 and also duplicates within the output of DG9

does this format look ok?

thanks

[Luke_C]

Hi @Hi2023 

The syntax looks fine, can you attach some sample data that illustrates the problem along with your expected output?

[binuacs]

@Hi2023 I think the condition checking for an empty string might be causing the issue. Can you try the below formula

IF [DG10Count] > 1 THEN "DS-"+[Dup_System_10] 
ELSEIF [DG9Count] > 1 AND isEmpty(Trim([STATUS])) AND  [STATUS] = "Open" THEN "DS-"+[Dup_System_09] 
ELSEIF [DG8Count] > 1 THEN "PS-"+[Dup_System_08] 
ELSE "NO DUP" 
ENDIF

[Hi2023]

thanks but now DG09 is all blank?

[Luke_C]

@Hi2023 Can you provide sample data? Very difficult to troubleshoot otherwise.

[Hi2023]

SO, I THINK I AM GOING TO SEPARATE IT ALL OUT AND USE A SUMMARY TOOL & JOIN TO BRING ALL BACK

SHOULDNT IT BE :

IF [DG10Count]>1 THEN "PS"+"-"+[Dup_System_10] ELSE ENDIF 

IT WONT LET ME CLOSE OUT THE STATEMENT -IT STATES MALFORMED?

THANKS

[Luke_C · Accepted solution]

@Hi2023 Your else statement is empty. Try the below (or substitute Null() ) as needed. 

IF [DG10Count]>1 THEN "PS"+"-"+[Dup_System_10] ELSE NULL() ENDIF 

[Hi2023]

OH YA! LOL

THANKSSS

[Hi2023]

DISREGARD

[Hi2023]

.