Skip to main content
micheller78368722
Participating Frequently
April 28, 2016
質問

I am trying to create YTD fields on a form. I unchecked the field on Reset Form but they are still getting reset. What can I do?

  • April 28, 2016
  • 返信数 1.
  • 891 ビュー

I am trying to create YTD fields on a form. I unchecked the field on Reset Form but they are still getting reset. What can I do?

このトピックへの返信は締め切られました。

返信数 1

try67
Community Expert
Community Expert
April 28, 2016

Are you setting their value with a script? If so, make sure you also set the default value to the same string. Then they will maintain their values even when reset.

micheller78368722
Participating Frequently
April 28, 2016

Here is the script I am using to calculate the YTDAmt total.

(AmountRow1 + AmountRow2 + AmountRow3 + AmountRow4 + AmountRow5 + AmountRow6 + AmountRow7 + AmountRow8 + AmountRow9 + AmountRow10 + AmountRow11 + AmountRow12 + AmountRow13 + AmountRow14 + AmountRow15 + AmountRow16 + AmountRow17 + AmountRow18)

micheller78368722
Participating Frequently
April 28, 2016

There are many possible errors and you have not provided enough information to limit the number of possabilities.

How are you calculating the YTD value?

There are 3 possible answers.

Want is the result you are getting?


The 2nd screen shot above is the way I'm calculating the YTDAmt.

YTDAMT  then Properties then Calculate. The I keyed in the above

code in the simplified field notation.

AmountRow1 + AmountRow2 + ...

Its adding the fields together okay but I need to retain the

YTDAmt for the following month.