Yes, the use of := and = is reversed, switch those two....

You have the assignment ":=" and comparison "=" operators reversed. It should be...

if 'Com. %' = 1

and

Com := 'Total Fees'*0.1

The switch statement also works here...

switch 'Com %' do
case 1:
'Total Fees' * 0.1
case 2:
'Total Fees' * 0.09
case 3:
'Total Fees' * 0.08
end

@Steven, I guess I need to refresh the page before I post

Hi everybody, is it possibile to have a formula that  change automatically a choice field ?

example, I need to change a choice field depending the result of another formula field:

if "the result in the formula field is" <" a number" then "change the value of the choice field in: "x"

thanks

@MP... Not following 100% ...   So.. you have a choice field that has choices of RED, WHITE, BLUE .. and if the formula yields a number less than 100 .. you want the choices to be  A, B, C instead? 

Hi,thank you for your reply!

Sorry, I wasn't clear enough.

Well, I have a table called TO DO LIST with a choice field called STATUS, with 3 options: URGENT - NON URGENT - IN PROGRESS.  I have 2 dates field also: BEGIN DATE - END DATE.

I would like to find a formula that, for example, if today is between Begin Date and End Date, changes the value in the  choice field in IN PROGRESS or if today is Begin Date-1day change the field choice in URGENT. etc.

I don't know if is it possible.. I tried but it returns me an error like: the formula does not change the value.. or something like that.

Oh.. Yeah.. sure .. that is possible... you can just do something like ... 

let td := today();

if 'Begin Date' <= td and 'End Date">= td then 

      Status := 3; 

end;

That is assuming that 3 is your in progress value .. 

Sorry .. I see a type-o .. 'End Date" .. should be 'End Date'... disclaimer.. I did not test the code.. :) 

Yeah, i saw it..don't worry. Thank you.

unfortunately It doesn't work.. it returns the error message (word for word traduced): this formula could not change the values.

Yeah, a formula field doesn't change values, only triggers, so if you put this in a button or a fields property trigger after update it'll work....

Yep.. sorry .. I should have been more clear ..  evaluate the result of the formula in an appropriate trigger. 

Thank you very much guys for your help! As you can see i'm not very expert!;) I'll try !