I am using sum the following scriptsum(Table1.Row1[*].amount[*])to total
28 rows in a column however the script only seems to work on Row1 - I am
not sure what I am doing wrong -I am using formcalc and each cell is
labelled 'amount' and is a numeric field. The script is entered in a
numeric field labelled Total.I feel I am missing something simple but
not sure what.Can someone help?
I have a table with 9 columns and 28 rows - I have created a further row
at the bottom and I would like the total that columnI have labelled each
row 'cost' and the header row is labelled 'totalcost'I have made the
result cell a numeric field labelled totalI have tried formcalc but just
cannot to get this to work but realise it should be relatively simply -
can someone help please?Thanks
I am not sure what I am doing wrong - but using this script I get an
answer of zero? startT = StartTime.formattedValue endT =
EndTime.formattedValue differenceT = Time2Num(endT, "HH:MM:SS") -
Time2Num(startT, "HH:MM:SS")= Num2GMTime(differenceT, "HH:MM:SS")For the
answer field I use a numericfieldCan you help please?
HiI can't help you but wondered if you can help me as you say you have
part of a script that works. All I need is the time difference between a
start time and a finish time (ideally one that works overnight)So start
is 09:00 and finish is 16:00 the script gives answer 7:00 - if your
script can do that could you share it with me?Marc
I have tried to get this code to work but without any luck - I am not
sure what I am doing wrong - I have ensured the two fields are called
tstart and tend and am using formcalc and calculate - I tried adjusting
the code slightly but still without any luck.Please can you help?I am
trying achieve how much time between a start time and end time (ideally
a code that works overnight) - I am using Livecycle ES2var tStart =
Time2Num(tstart.formattedValue, "HH:MM:SS")var tEnd =
Time2Num(tend.formattedV...
I need to deduct time from two cells - ie cell one (called
DateTimeField1) is 16:30 and cell two (DateTimeField2) is 18:00 the
answer in cell 3 (NumericField1) should be 1:30Time could go over night
- so I need a script (formcalc) that will allow for this (ie start time
21:00 - finish time 07:00 = 10:00can anyone help please?
