topic Re: Formula can not be saved in Dashboards & Analytics Discussions

Formula can not be saved

paraskothari — Wed, 19 Jul 2023 09:00:16 GMT

How can I go ahead ? Kindly help in to this

Re: Formula can not be saved

JoeM — Wed, 19 Jul 2023 13:32:48 GMT

@paraskothari - It looks like you are missing a closing parenthesis at the end. Would you be able to add and try again?

Re: Formula can not be saved

RADSr — Wed, 19 Jul 2023 13:55:53 GMT

If what @JoeM suggested doesn't get you there - are you typing the column references?

I see that "Sales" in the data source <> "SALES" in the formula - which isn't necessarily wrong, but both the message and the red highlight indicates that Incorta doesn't know about the column references.

As a general troubleshoot for formula columns I'd add one component at a time. Drag "Units" over and test then type "-" and drag the column for COGS -- test, etc.

Also - drop the results into Excel and check the math. The parens can sometimes make the order of operations non-intuitive so you'll want to make sure Incorta is doing the same calculation you think it's doing.

Re: Formula can not be saved

JoeM — Wed, 19 Jul 2023 15:00:19 GMT

@RADSr , @paraskothari - Took another look and seems that my eyes are failing me. I'd lean into the response from @RADSr as next steps!

Re: Formula can not be saved

paraskothari — Thu, 20 Jul 2023 10:54:54 GMT

The error is as below.

Formula cannot be saved. Column 'SALES.SALES.AMOUNT_SOLD' is not defined

so, I Amount_Sold Column is not defined.

Re: Formula can not be saved

JoeM — Mon, 24 Jul 2023 17:31:36 GMT

Have you tried changing from 'SALES.SALES.AMOUNT_SOLD' to 'sch_sales.Sales.Amount_Sold'?
As @RADSr mentioned... double clicking on the desired field will add it to the editor in the proper format.