Hi - I am copying the same formula from another cell, and adjusting the start of the formula to another cell so should be straight forward, but I keep getting 'invalid formula'. Please see screenshot below.
Can someone please advise? Thanks
Hi @CommunityMember113484 , That's strange! You can click on the invalid formula message to take you to the position in the formula where there seems to be an error & troubleshoot that.
Hi
@CommunityMember113484
As i can see there is extra space in the Formula please remove that or write formula like this:
'Capital Deployed (m)' / 'I_Forecast FX Rates'. FX Rate[LOOKUP: 'D_P3# Products | Details' .Currency]
Bhumit Jain
One of the modules referenced in formula has "I _", not sure why such complicated naming. But when you paste it directly in formula editor dock/window, it ignored single quotes and assumed text after space as a fresh value, here _ is an invalid character to use as a starting character for any component, and hence the error. Either paste the formula directly into lineitem while in blueprint mode, and then expand formula editor window to update the formula, OR simplify your modules' naming convention to be more meaningful and standard. Cheers!
The problem with copy-pasting is it won't have the single quotes, but ideally there has to be single quotes for I_Forecast FX Rates module as it has a special character _(underscore).
If you refer to this module & line item, it will automatically add the single quote.
@Dikshant - if the name contains special characters without whitespace, then Anaplan would have pasted with single quotes. The culprit here is that extra space before underscore, because of which Anaplan failed to identify it as one single name and couldn't wrap it around single quotes.
Thanks - so I've copied the formula / added the single quotes, but I now get an error - not sure how this can be when it works for the other formulas?
The formula for 'I_P3 Product | Annual AUM & Cap Raised'.'Capital Deployed (£m)' is invalid:
'Capital Deployed (£m)' = 'Capital Deployed (m)' / 'I_Forecast FX Rates'.FX Rate[LOOKUP: 'D_P3# Products | Details'.Currency]
'I_Forecast FX Rates'.FX Rate is not a recognized line item or list member
Hi @CommunityMember113484 , Could you copy paste both the formulas? It looks like the original formula was correct with the extra space which is why it is not recognizing it now. Try pasting the formula with the space & the single quote at the start & end of the module name -
'I _Forecast FX Rates'.FX Rate[lookup….]
@AjayM - This is what I think, and I can give it a try later sometime:
If there is any special character or number in the module name, a single quote is to be surrounded with the module/line item name. Once we applied the formula, Anaplan removed that single quote after saving the formula for that line item.
Since he copied from another line item where the formula is already saved, it does not have a single quote by default. And then he copied the same formula to a different line item, expecting it to work. But since that module name has a special character, he needs to add single quotes around the module name in order to save the formula.
Let's say if the module name was I_Forecast without space, still it will give the same error.
I will check it myself later in the day to confirm my statement..😄
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
