This formula doesn't work:
=NL("Rows";"Obra";;"=NF(;""Total Ofertado"")-NF(;""Total Producido"";""Date filter"";"""&phasta&""")";">0")
where "phasta" is a named range with the "..31/03/2013" value. But if the the value is "31/03/2013" it works. The same error happens if use something like ""..""&"""&phasta&""".
what should I correct?
thanks!
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment ok, I saw the solution yo gave in another topic, this works fine:
=NL("Rows";"Obra";;"=NF(;""Total Ofertado"")-NF(;""Total producido"";""Date Filter"";""..31/03/13"")";"NUMBER&>0")
thanks a lot once again!!! -
Jet Reports Historic Posts I try this and doesn't work:
NL("Rows";"Obra";;"=NF(;""Total Ofertado"")-NF(;""Total Producido"";""Date filter"";NP(""DateFilter"";;"""&phasta&"""))";">0") -
Jet Reports Historic Posts Hi,
I believe some Nav flow fields expect a the flow filter to be a single date (like an end date) and others expect a date range. Probably in this case, your flow field (Total Producido) is expecting a single date, so it works when you enter the date, but not the date range. I'm just speculating, but this seems like the most likely cause of what you're seeing. Is there a problem with just specifying the single date rather than the range?
Regards,
Hughes -
Jet Reports Historic Posts well, don't know why but now this expression works:
=NL("Rows";"Obra";;"=NF(;""Total Ofertado"")-NF(;""Total producido"";""Date Filter"";""..31/03/13"")";">0")
the problem is that the results are not what I expect: I supposed that it should give me Rows of data where "Total Ofertado"-"Total producido" is >0, but the rows returned don't correspond with ">0".If I use the ">900" filter it returns just one row and with ">1000" it returns more rows, but the same rows with the ">100000000" filter. it seems that the filter is interpreted like text or similar…how should I correct it?
thanks!
Please sign in to leave a comment.