Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

knelsen - 09 Sep 2005 22:47 GMT

I’m designing a form with a repeating table into which users will enter a
date. I’m not really interested so much in the actual date, but rather how
many dates they enter. I want to take this number (i.e. the total number of
rows, or the position of the last row in the table) and divide this by the
total number of possible dates (entered manually into a textbox by the user)
to calculate a percentage. Any ideas?

Reply to this Message

JerryTh [MSFT] - 10 Sep 2005 00:38 GMT

You want to use an expression along the idea of
count(group2) div field5

Where group2 is the repeating row and field5 is the text box they entered a
number into.

Signature

This posting is provided "AS IS" with no warranty & confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm. Do not
send email to this alias. It is for newsgroups only.

> I’m designing a form with a repeating table into which users will enter a
> date. I’m not really interested so much in the actual date, but rather how
> many dates they enter. I want to take this number (i.e. the total number of
> rows, or the position of the last row in the table) and divide this by the
> total number of possible dates (entered manually into a textbox by the user)
> to calculate a percentage. Any ideas?

Reply to this Message