Level 1

0% to

Level 2

Tip /

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

View all

## Custom Calculation Formula Needed

paulh77730136
Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile

paulh77730136
Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile
paulh77730136
Level 1

28-12-2018

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?

#### Accepted Solutions (1)

MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

54 solutions
View profile

MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

54 solutions
View profile
MinusZero
Level 4

01-01-2019

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")