Project and Portfolio Management Practitioners Forum
cancel

What is the correct token for a table total?

Highlighted
David Wray
New Member.

What is the correct token for a table total?

I need to display/pull the total from a table on the request. In the manual the refer to an example that references the table token as [reqd.t..tc.p..total] however I can't seem to get this to work.

searching this form, a few people have quotes around the brackets. Other examples in the command and token reference use use a "TE" rather than the "TC" prefix to reference a table column.

1 REPLY
David Wray
New Member.

Re: What is the correct token for a table total?

It appears the problem is the quotes as well as the order of the "V" and VP option. Both had to match.


Rule on the form....
Select
'[REQD.T.BASELINE_COMPARE_II.TC.P.OMB_PS_EV.TOTAL]',
'[REQD.T.BASELINE_COMPARE_II.TC.VP.OMB_PS_EV.TOTAL]'
From sys.dual

Rule on the table to calculate the EV for each row...
Select
('[TE.P.PERCENT_COMPLETE]' / 100) * '[TE.P.OMB_PS_PV]',
('[TE.P.PERCENT_COMPLETE]' / 100) * '[TE.P.OMB_PS_PV]'
From Sys.dual