Hi,
I am writing a simple currency report and cannot understand why it won't work.
I have used =NL("Rows","Currency Exchange Rate",,"Starting Date",$D$3) where D3 is a date filter
then =NF($B6,"Starting Date")
=NF(B6,"Currency Code")
=NF(B$6,"Adjustment Exch. Rate Amount","Currency Code",D6)
but when I run it it comes up like this
IWhy would this be please?
Thanks
Rodney
Hello Rodney -
There are a couple of things I can think of that might cause this.
First, if I inadvertently include an extra character at the front of my NF function, Excel will treat the cell as if it were text, instead of a function. For example: Here, I placed a space before the equal sign (but I suspect other - even non-printing - characters would have the same effect):
Next, if the cell were somehow formatted as text, Excel will do the same thing:
once I run the report and return to Design mode, I have that issue, again (but without a character in front of my cell):
If you start, again, from a *blank* workbook and enter these three functions:
Does this continue in that new workbook?
Thankyou Harry, it was the text format issue. That has fixed it thanks.
My original thought was to set up a table whereby I show each currency rate for each date as below. I tried to filter each column to achive this but its not working. Would this be a simple fix?
& with formulas changed to txt so you can see them
thanks
Rodney
Hello Rodney -
It appears that you are attempting to apply a FlowFilter to the NF function. I'm guessing that no such FlowField has been configured in NAV.
If I understand what you are after, I would probably approach it like this:
Then, when I run my report, I would get something that looks like this:
Does that make sense?
If there can only be one change rate per currency per day, another option would be something like this:
which would result in this output:
Thanks Harry, I have got the second option to work'
Much appreciated & helping my learning too
Cheers
Rodney