so im using the expression builder to try calculate values. But output stays blank :
This is the expression :
=IIf([Job Level FW]>=13,[Sum of core 13-16 FW]/5,0) Or ([Job Level FW] Between 9 And 12,[Sum of 9-12 FW]/15,0) Or ([Job Level FW] Between 7 And 8,[Sum of 7-8 FW]/10,0) Or ([Job Level FW]<=6,[Sum of 1-6 FW]/13,0)
also tried this :
IIf ([Job Level FW] >= 13,[Sum of core 13-16 FW]/5,0)
elseIf ([Job Level FW] between 9 and 12,[Sum of 9-12 FW]/15,0)
elseIf ([Job Level FW] between 7 and 8,[Sum of 7-8 FW]/10,0)
elseIf ([Job Level FW] <= 6,[Sum of 1-6 FW]/13,0)
Any help would be appreciated