0

# exchange rate for current date

Feb 06, 2017 at 11:17 AM

140

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.

AMIT KUMAR
Feb 06, 2017 at 11:22 AM
0

try this.

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

Share
Former Member Feb 06, 2017 at 11:29 AM
0

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.

Show 1 Share

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
0

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.

Share
Former Member Feb 06, 2017 at 12:01 PM
0

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.

Share
AMIT KUMAR
Feb 06, 2017 at 01:12 PM
0

try this.

=last([exc.rate]) in report

Share
Former Member Feb 08, 2017 at 11:22 AM
0

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

Share