cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Compare attribute to date

daniel_weisblut86
Participant
0 Likes
982

Hi

I am trying to create a data action that get a calculation result if the year is the same as the year mention in certain dimension attribute (property) 

what is the script i need to use?

i tried his one but have an error

 

IF YEAR([d/LegalDoc].[p/DateStart]) = [d/Date].[p/YEAR] THEN
DATA([d/Measures]="Changes")=3
ENDIF

 

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

@daniel_weisblut86 

Assuming Start Year if of type Integer.

IF INT(YEAR([d/Date])) = [d/LEGALDOC].[p/DateStart] THEN

DATA()=3

ENDIF

 

daniel_weisblut86
Participant
0 Likes
Thank you Very much. im tried this script but dont understand what im writing wrong appriciate your help
daniel_weisblut86
Participant
0 Likes
Thank you Very much. im tried this script but dont understand what im writing wrong appriciate your help : IF INT(YEAR([d/Date])) = [d/LegalDoc].[p/DateStart] THEN Data([d/Measures]="Changes",[d/IAA_GLACCOUNT]="522383200")= RESULTLOOKUP([d/Measures]="StartAmount")/RESULTLOOKUP([d/LegalDoc].[p/TermDuration]) ENDIF
daniel_weisblut86
Participant
0 Likes
IF INT(YEAR([d/Date])) = [d/LegalDoc].[p/DateStart] THEN Data([d/Measures]="Changes",[d/IAA_GLACCOUNT]="522383200")= RESULTLOOKUP([d/Measures]="StartAmount")/RESULTLOOKUP([d/LegalDoc].[p/TermDuration]) ENDIF

Answers (0)