I have a formula in Suggested Values:
LIST(IF([Receipt_ID].[Supplier_ID]="XXXX", [Buy_CostEach]*3,IF([Buy_CostEach]<=20,[Buy_CostEach]*2,IF([Buy_CostEach]<=60,[Buy_CostEach]*0.6+[Buy_CostEach],IF([Buy_CostEach]<=100,[Buy_CostEach]*0.4+[Buy_CostEach],IF([Buy_CostEach]>=101,[Buy_CostEach]*0.3+[Buy_CostEach],"ERROR"))))))
This works in creating a new entry. However, editing the already made entry produces the "This entry is invalid". I am not sure why I am getting this as I have no VALID IF constraints and it works for all new entries.
-- Update
And... after 4 days of waiting for an answer, I figure out the answer myself. Ensure to set your Numeric digits correctly in Type Details, I had mine on 2 and I believe it was causing this error in my calculation. But hey... As I am a paying customer, I should have a lot quicker support. @ kamil ... the support guy... man... nearly 5 days coming up with no response... Hope this resolves someone else's issue.
Glad you figured it out!
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |