AmandaSvaleson
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Need help with if statement
I have a multi-conditional if statement. I have tried it both as a text and number format. I need it to be along the lines of: if([ibo position]="marketing manager with HOS",[commercial team total],[ibo position]="Marketing manager w/o hos",[Commercial team total],[ibo position]="Platinum Marketing Manager with HOS",[Commercial Team Total],null) I have also tried it as a case statement. The commercial team total is a number field, I need it to recognize if any of these three conditions are true I need it to return the value in the commercial team total field, otherwise nothing.Issues with MLM type Formulas/Relationships
Hey guys, I have a question. I am trying to build an app for paying an mlm type payment system. I have it worked out where the payments for each person and their shared commissions pull into a table. I cannot for the life of me figure out how to calculate the total amount of the overrides. I have four tables set up that I will need for sure with an optional fifth. I have a table for sales team members (IBOs), which is the parent to both the commissions and shared commissions table. I then have both of these tables set up as parents to a payments table which pulls in the payment information to combine under one IBO. I will obviously have multiple payments for each IBO so I have the key field set to being a concatenated version of date+ID number, converted to text which is working great, I just cannot figure how to get the sales numbers to total. I need it to look at if IBO # (from one record)= Mentor IBO (from another record in the same table) then pull in the total from a number formula field from the record they show as the mentor IBO. It seems like it won't look at separate records. It's driving me crazy!