Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team, I have a data in Table 1 like below.
Doing from calculation based on a Variable captured in the screen from User for each Doc No and calculating a percentage like in Table 2, which i can able to calculate.
I need to apply the Table 2 Percentage in Table 1 again and create Table 3 which I cant able to.
Can I somehow maintain a column away from the Dimensions used?
Or I can do a lookup from another calculated table? I cannot use load script as i have a user input variable in the calculation.
Doc No | Entity Code | Ori Amount | Curr Amount |
P1 | Cust A | 1000 | 500 |
P1 | Cust B | -500 | -450 |
P1 | Cust C | -200 | -150 |
P2 | Cust D | -500 | -200 |
P2 | Cust E | 640 | 250 |
Table 2:
Doc No | Perc |
P1 | 25% |
P2 | 50% |
Table 3:
Doc No | Entity Code | Ori Amount | Ori Amt Perc |
P1 | Cust A | 1000 | 250 |
P1 | Cust B | -500 | -125 |
P1 | Cust C | -200 | -50 |
P2 | Cust D | -500 | -250 |
P2 | Cust E | 640 | 320 |
Hello @Venkatesh11789
I think I fix your problem.
The expression to put in the field in the tabel:
=if([Doc No] = 'P1',[Ori Amount] * 0.25,[Ori Amount] * 0.50)
The name of the label:
Ori Amt Perc
In the following prints you can see what have I done