Max value in a time dimension

Options
pabloSB
pabloSB Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor
in Planning & Modeling

Hello!

I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea?
In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3.

pabloSB_0-1636417870647.png

Any suggestions to obtain the max value (10)????
Thanks!
Pablo

Tagged:

Comments

  • pabloSB
    pabloSB Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor

    thanks for the response, super helpful! it works perfect!

     

    Pablo

  • pabloSB
    pabloSB Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor

    @rob_marshall

    thanks for the response, super helpful! it works perfect!

Categories