I'm kind of stuck using the table builder, in combination with the formula's.
Simple formulas like work:=NP("Formula";"month([@[Posting Date]])")
But when I try a formula with more arguments, excel stops and gives an error:=NP("Formula";"left([@[Name]];2)")
What am I doing wrong?
On top of that, even the working ones return a "#NAME" where the value should be, I have to "go in" the cell (F2) and "enter" to refresh them and make them work after a report is run.
This isn't too big an issue, but when you have 10 calculated fields, it's a bit daft.
The documentation isn't too big on the NP Formula either.
Thanks in advance,
Jan
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Jan,
You have to enter formulas in the Table Builder (or the NP(Formula) function if you're using that directly) using the English US formula format for them to work. So in the case of your example, you need to input the formula as this:=NP("Formula";"left([@[Name]],2)")
The ; instead of , will cause the formula not to work. I know this is kind of annoying and we're looking into ways to fix this (it's not as simple as it sounds!). But currently you have to enter the formulas in English US format for them to work.
Regards,
Hughes -
Jet Reports Historic Posts Thanks, I'll give it a try asap, though I thought I already tried that, could be mistaken though.
Please sign in to leave a comment.