IF , else clause

[RimDataAnalyst]

Hello , 

Hello ,

I want to understand between different documents to fill in the last document filled in, and here is the script that I insert in the data loading script just after loading the data

********************

current_document ='unvailable';

if( [Business Agreement]= 'True' , current_document = 'Business Agreement');

elseif( ([Trial Agreement] ='True' and [Business Agreement]= 'False') then current_document = 'Trial Agreement') ;

else

current_document = 'unvailable';

end if

******************

i think there is a syntax error someone could help please 

Thank you 

[justISO · Accepted solution]

Hi, I believe you are trying to define variable current_document. Try this:

LET current_document = if([Business Agreement]='True', 'Business Agreement', if([Trial Agreement]= 'True' and [Business Agreement]='False', 'Trial Agreement', 'unavailable'));

[RimDataAnalyst]

Thanks a lot it s working but when i want to add current_document to a visualization i can't find it