This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

Issue in multiplication with UDA

March 29 2017 at 3:07 AM
No score for this post
Garima 
from IP address 202.60.62.100

IF (@ISUDA("ACCOUNT","ELIM_ID: CAGRSPROFIT") OR @ISUDA("ACCOUNT","ELIM_ID: CAVOLUME"))--working
"A_505104000"=(@LDescendants(@UDA("Account","ELIM_ID: CAGRSPROFIT"),0 ))*-1;--not working

The second command is not working, please help.


 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply

Javier

173.180.74.50

Re: Issue in multiplication with UDA

No score for this post
March 29 2017, 11:29 AM 

Assuming you want A_505104000 to be equal to the sum of all Accounts with the UDA of ELIM_ID or CAGRSPROFIT, use the following:

"A_505104000" = @sum (@list (@uda ("Account", "ELIM_ID"), @uda ("Account", "CAGRSPROFIT"))) * (-1) ;

What is LDESCENDANTS supposed to return?

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
 
  << Previous Topic | Next Topic >>Return to Index  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.