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