InfoQube IM - Community

Submitted by jan_rifkinson on 2012/04/06 13:37

I searched thru knowledge base for row equations & I can't figure this out.

DateTimeIn = date <format>hh:mm</format>

DateTimeOut = date <format>hh:mm</format>

Duration = Number

RowEquation Duration (DateTimeIn, DateTimeOut)

Field names for ClockIn & ClockOut are DateTimeIn & DateTimeOut respectively

I DON'T GET IT !!!!

Comments

Hi Jan,

I'm sorry you're experiencing problems with this one. Was it working before, and when ?

Coud you post the Duration (DateTimeIn, DateTimeOut) function ? It's probably found either in :

tools -> Visual basic editor -> somewhere in : system code / user code / this database , depending on where it was added.

The function should start as :

Function Duration (

and it ends with End Function

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Hi Armando,

Thanks very much for your interest in my problem

I have no user code

In system code, I didn't see the Duration (DateTimeIn, DateTimeOut) function

I also copied entire code to notepad & searched it there w/o result

That may explain something about the problem

The when it stopped working is a harder one for me

I can say that it was working a few versions ago but can I pinpoint it for you?

No, I'm sorry.

Perhaps if you checked your system code to see if it exists that would answer one question

Maybe you could provide me the function code to insert in the user code section?

Thanks again.

Did you change Database recently ? This is strange.

Maybe Pierre made some changes to the system code function names. Dunno.

In any case I would then use the "CalcTaskDuration" function if it appears in your system code. It seems to be close enough to what you'd need.

Double check its presence (it should be there), it looks like that :

'-------------------------------------------
Function CalcTaskDuration(TaskStart, Duration, TaskEnd)
  dim d
  if isnull(TaskStart)=true then
    d=null
  elseif isnull(TaskEnd)=true then
    d=null
  else
    d=TaskEnd-TaskStart
  end if

  if d<0 then d=0
  CalcTaskDuration = d
end Function

If you have it (you should), the only thing you need to do is to replace your current duration equation (in the DURATION number field **row equation** text box) with this one :

=CalcTaskDuration( DateTimeIn , Duration, DateTimeOut) * 24

This should work. Tell me if it does !

(PS : note that the Duration value isn't really necessary in the function, but since it's there in the function parameters, just put it...)

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

That did it, Armando !! THANK YOU. I spent 2-3 days trying to figure that out.

To answer your question about the dB, by that I assume you are referring to the system equations.

If so, no, I did not change anything. To he honest I didn't know it existed there

I have a separate but related question:

Is it possible to use two equations for one field?

Example:

Work Period calculated by Duration

and

Materials = pieces x CostPerUnit

I'd like to have them totaled in column calc so I need them in same column

or do i need a separate column like Total Cost = Duration + Materials?

Thanks.

[quote]

I have a separate but related question:

Is it possible to use two equations for one field?

Example:

Work Period calculated by Duration

and

Materials = pieces x CostPerUnit

I'd like to have them totaled in column calc so I need them in same column

or do i need a separate column like Total Cost = Duration + Materials?

[/quote]

I'm not sure I understand exactly what you want... But it's certainly possible.

Can you restate what you want in each (and which) column ? What I don't get is the "Work Period calculated by Duration" and "I'd like to have them totaled in column calc so I need them in same column".

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

I solved the problem by adding a Total Cost field / column

That field calculates "labor costs" + "material costs"

"labor costs" is calculated by number of workers and number of hours worked, i.e. duration * rate (cost per hour)

"material costs is calculated by number of pieces * cost per piece.

I now have this set up in one long row

and

I have column calculation so I can see how much each project is costing dynamically.

It's nothing fancy but it works.

Once again, thanks for your interest in helping me solve this problem.

Great work, Jan !

It doesn't need to be fancy. If it works and it's clear, it's enough IMO.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Great news that you got it working Jan,

I just noticed that your field, named Duration was calling the function Duration ... name conflict is most likely the cause of the problem...

HTH !

Ahhhh., You mean it was another one of those RESERVED words?

No, not a reserved word, but a field calling a function of the same name, the parser probably confused the function name with the field name.

I'll think about it, but seems to me that having one's field name in any equation should not be allowed, as it will lead to recursion and possible infinite loops...

[quote=Pierre_Admin]

I just noticed that your field, named Duration was calling the function Duration ... name conflict is most likely the cause of the problem...

[/quote]

There seemed to be no "duration" function in the user/database/system code though.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

I am getting Equation error "Invalid Character" or "type mismatch number 0" <SOLVED by Armando>

Comments