exchange rate for current date

[Former Member]

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

[Former Member]

Amit, this formula returns the highest value for the exchange rate. Not the last bu the highest.

[amitrathi239]

try this.

=last([exc.rate]) in report

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[amitrathi239]

can you explain in detail what is required?

Are you looking to display data for Current month/Year only or something else?

[amitrathi239]

try this.

=([exc.rate]) Where (([month]= [Current month]) and ([Year]=Year(currentdate()))