Multiple conditions

Tue, 10 Feb 2015 21:39:44 GMT

I am trying to create an expression that checks for year first and then I want it to pull the max year, period record to get the value.

I concatenated the Year & Period at the time of load. I call that YR_PRD

I also have an input box to allow the user to enter the fiscal year they want to look at.

Here's an example of what my data looks like:

Asset# Year Period Depreciation$

100 2014 1 15.00

100 2015 1 14.00

100 2014 2 17.00

100 2015 2 16.00

100 2014 3 16.50

100 2015 3 17.50

So if I input 2014, I want the 2014 period 3 record to pull the $16.50 since that is the max yr_prd in the record.

How can I create the expression to pull this record?????

Re: Multiple conditions

rwunderlich — Tue, 10 Feb 2015 23:26:35 GMT

Something like (not syntax checked)

=FirstSortedValue({<Year={$(vYear)}>} Depreciation$, -Period)

-Rob

Anonymous — Wed, 11 Feb 2015 04:57:17 GMT

Hola,

PFA

HTH