Primavera (MOSC)

MOSC Banner

Primavera Analytics - Is it possible to calculate a delta between two monthly historical values?

edited Dec 25, 2019 4:00AM in Primavera (MOSC) 1 commentAnswered

I have an analysis which which consists of a pivot table showing two columns for monthly historical date fields (BP Counts in one case, Early Start dates in another case) from the Activity History subject area, and I wish to calculate the difference between the two. 


While it is fairly straightforward to calculate a delta between a current value for an activity and a value from the history table, I am unable to see any way to calculate the difference between the two historical values as the two columns are both identified as "Month".   I've tried using a presentation variable in the analysis which names the columns based upon a user's input, and while this works if I provide default values for the presentation variables it fails when I take the default values out and use a prompt to fill them.  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center