on 2023 Feb 16 4:30 PM
Hello,
i saw in a sample Content that it is possible to combine two Tables with a Lookup and make Calculations, so you dont have to use a Join. So i tried to combine two Tables, Table 1 and Table 2, please see below:
I used Table 1 as Input in my Calculation Function:
As lookup-Input i used Table 2:
Then in the Formula of the Field AMOUNT1 I typed in the following Logic: The Lookup Field is GL_ACCOUNT
I also typed in the following different Logics, which was also possible to activate:
So it should add everywhere where GL_ACCOUNT matches (ACC1 and ACC2) a 10 if its ACC1 and a 5 if its ACC2.
Its possible to activate this but when i see the results:
AMOUNT1 should be filled with 5+10; 4+10;3+10 for GL_ACCOUNT=ACC1 and 4+5;10+5 for GL_ACCOUNT=ACC2 right ?
No Addition takes place obviously. Can s.o tell me the correct Code please ?
Best Regards, Philipp
Request clarification before answering.
Hi Philip,
Please try below:
AMOUNT1+14935.QUANTITY[GL_ACCOUNT='ACC1']
Regards,
Akshay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.