Total Formula (Column Total versus Row Total)

Avatar

Avatar

melindal5122814

Avatar

melindal5122814

melindal5122814

27-03-2017

I'm currently working on a table where I need to configure the total amount worked by their pay rate. When I create the total formula it doesn't work. The formula I had was $.rawvalue= Rows.WorkTotal.Cell3 * Rows.PayRate.Cell3. Could I please get some guidance on what I could get done?

Accepted Solutions (0)

Answers (7)

Answers (7)

Avatar

Avatar

Subramaniv22778

Avatar

Subramaniv22778

Subramaniv22778

29-03-2017

if (NumericField.rawValue > 50)

{

xfa.host.messageBox("You can't exceed $50!","Error",3,1);

NumericField.rawValue="";

xfa.host.setFocus(NumericField);

}

Write this under 'Javascript' , for the event 'Exit'. Replace 'NumericField' by your FieldName.

Avatar

Avatar

melindal5122814

Avatar

melindal5122814

melindal5122814

29-03-2017

Subramaniv22778​, I checked on whether its Formcalc and it was under javascript. And it fixed the issues. The other question I had was do you know what the formula would need to be if I needed put a limited number they could enter? For example, they are putting in the expense amount for meals and it can't exceed $50 per day. How would I go about scripting that?

Avatar

Avatar

Subramaniv22778

Avatar

Subramaniv22778

Subramaniv22778

28-03-2017

Check whether its under 'Formcalc' and Columns Vs Rows?

Avatar

Avatar

melindal5122814

Avatar

melindal5122814

melindal5122814

28-03-2017

Hi Subramaniv22778,

Yes, I have it under the event "calculate" I'm not sure on on the FormCalc instead of Javascript. I'll have to double check. Would it matter if I was working with total columns versus rows?

Avatar

Avatar

Subramaniv22778

Avatar

Subramaniv22778

Subramaniv22778

28-03-2017

Have you written the script under 'Formcalc' instead of 'Javascript'? and put it for the event 'Calculate'

Avatar

Avatar

melindal5122814

Avatar

melindal5122814

melindal5122814

28-03-2017

HI @Mangus069,

The issue Im having if after putting in that formula to in the Total field and switch over the PDF to input the two data (WorkTotal * PayRate) points to get the total the information doesn't show or sum up in the PDF.

Avatar

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150
Magus069
MVP

28-03-2017

Hi there,

not quite sure what the error can be, you do not give much details about the behavior or any errors that occur...

but by looking at the formula you have written in the forum, let's say rawvalue needs a capital 'V' -> rawValue

Hope this help!