I am pulling in a rate of commission from a field in CiviCRM. I have also pulled in a number of payments. But the commission is not connected to each payment. Here's what I want to make...
Commission Organization First Name Last Name €-Paid €-Commission €-Net
0.3 My Agency Jim Smith 100 30 70
0.3 My Agency_2 Jane Murphy 100 0 100
0.3 My Agency_3 Tom Thumb 100 0 100
- Field "€-Commission" => Multiplies "Commission" x "€-Paid"
- Field "€-Net subtracts" => Subtracts "€-Commision" from "€-Paid" to produe a net amount
The problem is that the commission rate of is only input as a custom field (separate table) from the profile of the agency. It only appears one time and it is not connected to the payments.
I need to find a way to apply this commission figure to all the rows in the view. I'm guessing, but thought something like this logic might work:
IF field_Commission = 0.3;
Then make all rows in that column equal 0.3
I'm not a programmer and pretty rusty with views, so really appreciate any help anyone can give.
Thanks!
Comments
Comment #0.0
lionsharz commentededit
Comment #0.1
lionsharz commentedspellings
Comment #0.2
lionsharz commentedmore info
Comment #0.3
lionsharz commenteded
Comment #0.4
lionsharz commenteded
Comment #1
mustanggb commented