Hello
I am using Jet Essential and I am using the Month formula in table builder to bring the month number into the table.
The problem I am having is that it is treating the formula as text every time I refresh the report.
Does anyone know how to stop this?
The formula I am using is =MONTH(@Entered On) in the table builder
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello -
When in the Table Builder, does your function look like this?
And in Excel, does it look like this?
-
Scott Paterson Hi, I know this is an old post but is the problem I have. I add formulas in the table builder but when I run them, they come out like text...any help would be great as it is driving me mad :)
This is an example formula that isnt working...
=@NP("Formula","=IF([@[Curr]]="USD",[@[USD Val]]/1.22,IF([@[Curr]]="EUR",[@[EUR Val]]/1.19,[@[GBP Val]])")
Can anyone see why this isnt working? I have tried various versions with and without (), [ ] and " with no success?
Thanks in advance
-
Scott Paterson ok, so i fixed it, but for anyone needing this thread, this was the answer...
=@NP("Formula","=IF([@[Curr]]=""USD"",[@[USD Val]]/1.22,if([@[Curr]]=""EUR"",[@[EUR Val]]/1.19,[@[GBP Val]]))")
It needed another ) at the end (makes sense) but also double quotation marks on the text fields - ""USD"".
Does anyone know if that is normal or why the extra set of quotation marks are needed?
Please sign in to leave a comment.