Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am having difficulty getting the most recent value of of 'BalanceRemaining' from a single table containing DealCode (key field), ValueDate and BalanceRemaining (among other fields of no importance here).
I have a straight table using DealCode as dimension, and the following expressions (bear in mind that these expressions are for testing purposes). One deal is currently selected.
NOTE: when I have finished testing I will change the Count to Only to get the value of the BalanceRemaining field.
My two questions are:
Many thanks
Jonathan
1) FirstSortedValue() might work for you here.
2) Assuming ValueDate is already a date, do you actually need the date() function? What is the actual value of ValueDate - is it 2010/08/31 ?
(Bump) Anyone?
1) FirstSortedValue() might work for you here.
2) Assuming ValueDate is already a date, do you actually need the date() function? What is the actual value of ValueDate - is it 2010/08/31 ?
Hi
I think that the expression 6, need a "TOTAL" in the function MAX and you need verify the "(" and ")" because you have a 4 "(" and 5 ")"
COUNT(IF(ValueDate = Date(Max(TOTAL ValueDate) ), BalanceRemaining))
Do you have a qvd example ?
Steve
Thanks for your suggestion which got me on the right track. The answer was:
FirstSortedValue({<TaxStatus={'Cl'}>} Total <DealCode> BalanceRemaining, -ValueDate)
which works perfectly.
Jonathan