-
1. Re: Replacing a value with a different calculation
Prabhakar Nalla Jan 22, 2019 4:34 AM (in response to Patrick Weber) -
2. Re: Replacing a value with a different calculation
Patrick Weber Jan 22, 2019 4:43 AM (in response to Prabhakar Nalla)No Johns calculation is based on product manager id of all products. That means if e.g. James, Jim or John himself sell products where product manager id = 200 or id= 100 then John will get commission.
-
3. Re: Replacing a value with a different calculation
Zhouyi ZhangJan 22, 2019 4:51 AM (in response to Patrick Weber)
Hi, Patrick
Please find my soluiton attached.
Below is the screenshot of result for your reference.
Hope this helps
ZZ
-
my Example_v10.2.twbx 21.2 KB
-
-
4. Re: Replacing a value with a different calculation
Patrick Weber Jan 22, 2019 6:32 AM (in response to Zhouyi Zhang)Thanks this is a great solution. Could you explain what's happening in this calculation?
-
5. Re: Replacing a value with a different calculation
Zhouyi ZhangJan 23, 2019 5:37 AM (in response to Patrick Weber)
Hi, Patrick
Do you mean the function of Size() ?
size() is actually a portion in the view, in this case, grand total only has 1 portion, so we can use this to assign the value specifically.
and when size() <>1, it comes to the detail rows. And per your requirement, the calculaiton for John is different, so that's why I use if-else.
Hope this makes sense.
ZZ