Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Again,
=sum({<Date={'4/4/2012'}>}[In company code currency_HSL]*-1*RatetoUSD)
And the one I need to work below does not:
=sum({<Date={$(max (Date)) }>}[In company code currency_HSL]*-1*RatetoUSD)
Thanks again
Hi,
Use the expression like this
= Sum({<Datefield={'$(=vMaxDate)'}>}[In company code currency_HSL]*-1*RatetoUSD)
Where vMaxDate = Max(Datefield)
Regards,
Iyyappan
Hi,
Use the expression like this
= Sum({<Datefield={'$(=vMaxDate)'}>}[In company code currency_HSL]*-1*RatetoUSD)
Where vMaxDate = Max(Datefield)
Regards,
Iyyappan
Sean
Two possible issues:
Hope that helps
Jonathan
Thank you. This example worked where the other preply to my question did not. Any thoughts as to why it worked using a variable for max date vs the other examples?
Thank you,