You are viewing limited content. For full access, please sign in.

Question

Calculation on table fields based on a variable SUM and SUMIF

Forms

Updated September 4, 2019

asked on September 4, 2019

My syntax must be just a bit off please help. I am trying to get the % from 2 different tables based on their cost object. OtherStaff.V0105 and ParaTeacher.ParaCostObj = 0105. It looks like I should be able to put the whole thing in a SUM statement but, so far I am getting calculation error on every attempt. Here is the current iteration of my calculation field. I have tested the SumIf statement and the SUM statement and they work separately.

=SUM((OtherStaff.V0105 * 100 / TTLOtherHours) , (SUMIF(ParaTeacher.ParaCostObj, "=0105",ParaTeacher.ParaMinutes) / ParaTotalMins * 100))

0 0

Replies

replied on September 4, 2019

I could be off also. But the '=' inside the parentheses doesn't seem like it belongs. Usually when it is looking for the value that it compares it to it assumes it equals whats in the "". Try removing it and seeing if that helps.

Because written in plain text this reads:

Get the sum of (OtherStaff.V0105 * 100 / TTLOtherHours) plus ((The sum of ParaTeacher.ParaCostObj if it equals "=0105" with a range of ParaTeacher.ParaMinutes) / ParaTotalMins * 100))

So to me, it says that ParaTeacher.ParaCostObj is supposed to equal =0105 and it sounds like you want it to just equal 0105.

Question

Question

Calculation on table fields based on a variable SUM and SUMIF

Replies

Sign in to reply to this post.