Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

SOLVED

## Custom Calculation Formula Needed

Level 1

I have 31 text boxes, one for each day of the month.  In each text box there are 5 or 6 different entries, such as P, T, AB, AT.  I want to create a field to total the P's and T's but not the AB's and AT's.  How do I do that?

1 Accepted Solution

Level 7

Hi, You could try this.

I created a button to calculate the totals. My test uses only 5 textfields.

In the calculate button i had:

form1.#subform[0].Button1::click - (JavaScript, client)
var totP = 0; //set variable for the Ps
var totT = 0; //set variable for the Ts

if(TextField1.rawValue == "P")
{
totP = totP + 1;
}
if(TextField2.rawValue == "P")
{
totP = totP + 1;
}
if(TextField3.rawValue == "P")
{
totP = totP + 1;
}
if(TextField4.rawValue == "P")
{
totP = totP + 1;
}
if(TextField5.rawValue == "P")
{
totP = totP + 1;
}

if(TextField1.rawValue == "T")
{
totT = totT + 1;
}
if(TextField2.rawValue == "T")
{
totT = totT + 1;
}
if(TextField3.rawValue == "T")
{
totT = totT + 1;
}
if(TextField4.rawValue == "T")
{
totT = totT + 1;
}
if(TextField5.rawValue == "T")
{
totT = totT + 1;
}

totalP.rawValue = totP; //display the total Ps
totalT.rawValue = totT; //display the total Ts

This is one way to do it. Some considerations are that javascript is very particular. T is not the same as t. You would need to account for that. eg: if(TextField1.rawValue == "T" || TextField1.rawValue == "t")

Level 7

Hi, You could try this.

I created a button to calculate the totals. My test uses only 5 textfields.

In the calculate button i had:

form1.#subform[0].Button1::click - (JavaScript, client)
var totP = 0; //set variable for the Ps
var totT = 0; //set variable for the Ts

if(TextField1.rawValue == "P")
{
totP = totP + 1;
}
if(TextField2.rawValue == "P")
{
totP = totP + 1;
}
if(TextField3.rawValue == "P")
{
totP = totP + 1;
}
if(TextField4.rawValue == "P")
{
totP = totP + 1;
}
if(TextField5.rawValue == "P")
{
totP = totP + 1;
}

if(TextField1.rawValue == "T")
{
totT = totT + 1;
}
if(TextField2.rawValue == "T")
{
totT = totT + 1;
}
if(TextField3.rawValue == "T")
{
totT = totT + 1;
}
if(TextField4.rawValue == "T")
{
totT = totT + 1;
}
if(TextField5.rawValue == "T")
{
totT = totT + 1;
}

totalP.rawValue = totP; //display the total Ps
totalT.rawValue = totT; //display the total Ts

This is one way to do it. Some considerations are that javascript is very particular. T is not the same as t. You would need to account for that. eg: if(TextField1.rawValue == "T" || TextField1.rawValue == "t")