| Author |
Message |
Sergej Grickov
Guest
|
 Posted:
Thu Jan 13, 2005 1:12 pm Post subject:
Trouble with calculated field |
|
|
Hello, all
I have created custom list with three fields, where field A is a choice with
values,
field B is a number field and field C is a number field too.
I want to create a calculated field D with formule
=IF ([A] = "x", [B]*[C]/1000, IF([A] = "y", [B]*[C]/100, [B]*[C]))
but I got an error with message: The formula contains a syntax error or is
not supported.
Where I am missing ?
Platform: Windows SharePoint Services 2.0 with SP1 (Lithuanian Language
Pack).
Please, help me ASAP.
Best regards,
Sergej Grickov.
Kaunas, Lithuania. |
|
| Back to top |
|
 |
Boris Gomiunik
Guest
|
| Posted:
Thu Jan 13, 2005 1:25 pm Post subject:
Re: Trouble with calculated field |
|
|
Hi, the problem can be very simple. Instead of comas (,) use semicolons (;).
Let me know if this works.
Thanks again Mike for pointing that out.
"Sergej Grickov" <Sergej@ekb.lt> je napisal v sporočilo
news:%23d0g58T%23EHA.2700@TK2MSFTNGP14.phx.gbl ...
| Quote: | Hello, all
I have created custom list with three fields, where field A is a choice
with values,
field B is a number field and field C is a number field too.
I want to create a calculated field D with formule
=IF ([A] = "x", [B]*[C]/1000, IF([A] = "y", [B]*[C]/100, [B]*[C]))
but I got an error with message: The formula contains a syntax error or is
not supported.
Where I am missing ?
Platform: Windows SharePoint Services 2.0 with SP1 (Lithuanian Language
Pack).
Please, help me ASAP.
Best regards,
Sergej Grickov.
Kaunas, Lithuania.
|
|
|
| Back to top |
|
|
Sergej Grickov
Guest
|
| Posted:
Thu Jan 13, 2005 1:39 pm Post subject:
Re: Trouble with calculated field |
|
|
Thank you !
It's work!
Sergej.
"Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> wrote in message
news:ulRmqGU%23EHA.2016@TK2MSFTNGP15.phx.gbl...
| Quote: | Hi, the problem can be very simple. Instead of comas (,) use semicolons
(;). Let me know if this works.
Thanks again Mike for pointing that out.
"Sergej Grickov" <Sergej@ekb.lt> je napisal v sporočilo
news:%23d0g58T%23EHA.2700@TK2MSFTNGP14.phx.gbl ...
Hello, all
I have created custom list with three fields, where field A is a choice
with values,
field B is a number field and field C is a number field too.
I want to create a calculated field D with formule
=IF ([A] = "x", [B]*[C]/1000, IF([A] = "y", [B]*[C]/100, [B]*[C]))
but I got an error with message: The formula contains a syntax error or
is not supported.
Where I am missing ?
Platform: Windows SharePoint Services 2.0 with SP1 (Lithuanian Language
Pack).
Please, help me ASAP.
Best regards,
Sergej Grickov.
Kaunas, Lithuania.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in