Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago

Location Revenue Assignment

So in the attached image I have a sample from a spreadsheet.  Each student has a "Student Campus Location" that is considered their home location.  They can take courses at another location and it wo...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

What mechanism are you proposing for assigning it to a course campus location?

 

For the first part of your question, you can get the campus course location total by the following:

 

Column = IF([Student Campus Location] = [Course Campus Location],[Course Tuiton],0)

The total of that column would give you the total for the student's tuiton at their campus location. Now, you could create similar columns, one for each course location and fill them with similar formulas.

  • JMWDBA's avatar
    JMWDBA
    Icon for Advocate II rankAdvocate II
    9 years ago

    I am not certain I understand the question about mechanism.