Forum Discussion
Using parameter table to make new column
The answers to almost all of your questions are to do with how you link to the other table from the 'many' side.
You have to use the RELATED function. The intellisense (autocompletion) is smart enough to give you only items that it thinks you can use according to the template of the functions you call.
The answers to almost all of your questions are to do with how you link to the other table from the 'many' side.
You have to use the RELATED function. The intellisense (autocompletion) is smart enough to give you only items that it thinks you can use according to the template of the functions you call.
Hi HotChilli,
Thanks, this works
Report_Commission = ROUND(IF(Booking[Code]="A"; Booking[Memberschip] + Booking[Installment] * RELATED(Commission_Parameters[Commission%]) / RELATED(Commission_Parameters[Tax%]); Booking[Commission]);2)
R.W.