Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'));
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'));
Thanks a lot it s working but when i want to add current_document to a visualization i can't find it