Custom Calculation Formula Needed

Avatar

Avatar
Level 1
paulh77730136
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
paulh77730136
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

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)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
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.

1658197_pastedImage_0.png

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

1658198_pastedImage_1.png

Answers (0)