Skip to Content
0

exchange rate for current date

Feb 06, 2017 at 11:17 AM

112

avatar image

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

sap-answer.jpg (54.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

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

try this.


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

Share
10 |10000 characters needed characters left characters exceeded
Ofeliya Sofiyeva 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
10 |10000 characters needed characters left characters exceeded

can you explain in detail what is required?

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

0
Ofeliya Sofiyeva 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.


sap-ask.jpg (44.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Ofeliya Sofiyeva 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.


sap-ask.jpg (44.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 06, 2017 at 01:12 PM
0

try this.

=last([exc.rate]) in report

Share
10 |10000 characters needed characters left characters exceeded
Ofeliya Sofiyeva 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
10 |10000 characters needed characters left characters exceeded