Hi, everyone.
I need to get exchange rate value for a current month.
In my database, I have an exchange rate for all months. In my webi report, I try to get exchange rate only for the current month.
I have current month variable, current date variable. When I wrote formula like
=([exc.rate]) Where ([month]= [Current month]) it returns formula for all February, for all years.
I can't add the last year variable to this formula.
I need to receive 0.5 (currency rate for February 2017) for all cells.
Need your help.
Thanks in advance
try this.
=([exc.rate]) Where (([month]= [Current month]) and ([Year]=Year(currentdate()))
Hi Amit. Thank you quick responce. I have tried this formula but it returns value only for the last cell. I mean other cells are still empty. I need to get this result for all cells.
can you explain in detail what is required?
Are you looking to display data for Current month/Year only or something else?
Amit I need the table as shown below. But when I wrote the formula which you have given, it gives a result only for the last day, and other cells left empty.
Amit I need the table as shown below. But when I wrote the formula which you have given, it gives a result only for the last month, and other cells for other months left empty.
try this.
=last([exc.rate]) in report
Amit, this formula returns the highest value for the exchange rate. Not the last bu the highest.