cancel
Showing results for 
Search instead for 
Did you mean: 

Formula can not be saved

paraskothari
Partner
Partner

How can I go ahead ? Kindly help in to this

5 REPLIES 5

JoeM
Community Manager
Community Manager

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

JoeM
Community Manager
Community Manager

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

RADSr
Partner
Partner

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.  

 

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.