Adding up colums, including rubric columns

  • james.me.robinson
  • Offline
More
5 years 10 months ago #7970 by james.me.robinson
Adding up colums, including rubric columns was created by james.me.robinson
Hi Bert,

I am trying to calculate the total addition over several columns, including some rubric totals. At the moment, the rubric column is showing 36/36, however when the addition column takes this into account, it is counting this as 1 rather than as 36. Is there a way to get around this?
More
5 years 10 months ago - 5 years 10 months ago #7971 by bert
Replied by bert on topic Adding up colums, including rubric columns
Hello James,
If you use the 'Percentage over total addition' option in 'Addition', the rubric's total points will be shown instead.
If you use a simple formula (add column > calculation > formula) and use the RAW function it will take into account those points instead of the fraction.
It would look like this
COLUMN1 + COLUMN2 + RAW(RUBRIC) + COLUMN3
Last edit: 5 years 10 months ago by bert.
The following user(s) said Thank You: james.me.robinson
  • james.me.robinson
  • Offline
More
5 years 10 months ago #7972 by james.me.robinson
Replied by james.me.robinson on topic Adding up colums, including rubric columns
Thanks Bert. All sorted! Much appreciated.