Skip to Content
avatar image
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.

Need your help.

Thanks in advance

sap-answer.jpg (54.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Feb 06, 2017 at 11:22 AM

    try this.


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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2017 at 01:12 PM

    try this.

    =last([exc.rate]) in report

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 11:22 AM

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

    Add comment
    10|10000 characters needed characters exceeded