Former Member

### exchange rate for current date

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.

10|10000 characters needed characters exceeded

• Feb 06, 2017 at 11:22 AM

try this.

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

10|10000 characters needed characters exceeded
• Former Member
Feb 06, 2017 at 11:29 AM

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.

10|10000 characters needed characters exceeded
• can you explain in detail what is required?

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

• Former Member
Feb 06, 2017 at 12:00 PM

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.

10|10000 characters needed characters exceeded
• Former Member
Feb 06, 2017 at 12:01 PM

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.

10|10000 characters needed characters exceeded
• Feb 06, 2017 at 01:12 PM

try this.

=last([exc.rate]) in report