Issue in multiplication with UDA

Issue in multiplication with UDA

Joined: March 29th, 2017, 6:58 am

March 29th, 2017, 7:07 am #1

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.

Quote
Like
Share

Joined: April 13th, 2011, 5:00 pm

March 29th, 2017, 3:29 pm #2

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?
Quote
Like
Share


Confirmation of reply: