Hello Vladimir,
For some time I have been trying to figure out how to use modifiers in formulas but I am at a loss regarding their use. I manage to create formulas using modifiers but it's more of a trial and error process.
I found it useful to be able to set distance lags for infrastructure projects. In order to use such a lag I use the following fields:
- Start Location
- Finish Location
- User Field called Distance Lag [m], wich contains the distance between 2 activities
- Formula, which is applied in the Links table, formula which computes (depending on the type of links - SS or FF) the volume of the lag according to the Distance.
The formula is as follows:
Lag = if ( LagType = 'Volume' and LagUnit = 'Unit of volume', RoundTo ( if ( Code [ Code , ?PredCode , GanttAct ] = PredCode and TypeSF = 'Start-Start', VolPlan [ Code , ?PredCode , GanttAct ] / ( LocFin [ Code , ?PredCode , GanttAct ] - LocStart [ Code , ?PredCode , GanttAct ] ) * Dist_Lag [ Code , ?PredCode , GanttAct ], If ( Code [ Code , ?PredCode , GanttAct ] = PredCode and TypeSF = 'Finish-Finish', VolPlan [ Code , ?SuccCode , GanttAct ] / ( LocFin [ Code , ?PredCode , GanttAct ] - LocStart [ Code , ?PredCode , GanttAct ] ) * Dist_Lag [ Code , ?PredCode , GanttAct ], Lag ) ), 4), Lag )
The problem I have is that I don't fully understand modifiers and cannot get the formula to be called from the Activity Gantt into the Links Table.
If you could go into more detail on using Formulas and Modifiers it would be much appreciated.
Best regards,
Bogdan