We have evaluating
Contract Manager 12 and we like to know if this product
permit do calculation between custom field, example.<br
In the drawing Module I create: <br
field A: weigth<br
Field B: progress<br
need to calculate C:<br
Field C: total progress= A*B
possible to do this one?
I know that I can to
do mathematics operation in Infomaker but I need to save
the result in the database.<br
I appreciate any assistance.<br
You are correct
that the calculation in infomaker won't be saved to
the database. There may be a way to work around the
issue. I'd recommend contacting our Customer Support
group to see if there is a way to tackle this. You can
find information about contacting them here:<br
Thanks for the information James,
/>I received a recommendation of technical support
of Contract Manager that one road is usign API
application. We are going try for this road.<br
(Primavera close your eyes)...
/>It is possible to write a custom trigger in the
database to perform this calculation whenever a change
is made to the value of either Custom Field A or B to
update the value in CF C.
in mind, this kind of thing is not supported and can
be risky especially when upgrading to a new version.
What database are you running against? The syntax will
vary depending on the platform. Post your SQL you use
for the calculation. An alterntative to using a
trigger (and using a Windows scheduled task) would be
to schedule this within the database. I know that
Sybase has something called Events where you can have
this SQL run at specified intervals.