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

lionsharz’s picture

Issue summary: View changes

edit

lionsharz’s picture

Issue summary: View changes

spellings

lionsharz’s picture

Issue summary: View changes

more info

lionsharz’s picture

Issue summary: View changes

ed

lionsharz’s picture

Issue summary: View changes

ed

mustanggb’s picture

Issue summary: View changes
Status: Active » Closed (outdated)