You need to sign in to do that
Don't have an account?
Tillu
How to give Text value in formulae editor?need help
with the workflow I need to update a field value with text. when i give text in one line with double quotations its fine.
but my text value has 8 lines , i am getting syntax error when i give all this 4 lines in double quots.
error is : Missing "
the value that i need to give on formulae editor is :
B share Opt A – 7% fronted, 0.0% trail
B share Opt B – 5.75% fronted, 0.25% trail, year 2, paid qtrly
B share Opt C – 4.00% fronted, 0.50% trail, year 2, paid qtrly
B share Opt D – 3.50% fronted, 0.75% trail, year 4, paid qtrly
C share Opt A – 2.00% fronted, 1.00% trail, year 2, paid qtrly
C share Opt B – 1.15% fronted, 1.15% trail, year 2, paid qtrly
L share Opt A – 6.00% fronted, 1.00% trail, year 5, paid qtrly
L share Opt B – 4.00% fronted, 1.00% trail, year 2, paid qtrly
if i give all these in " " quotations getting error? how should i give this long text value?
but my text value has 8 lines , i am getting syntax error when i give all this 4 lines in double quots.
error is : Missing "
the value that i need to give on formulae editor is :
B share Opt A – 7% fronted, 0.0% trail
B share Opt B – 5.75% fronted, 0.25% trail, year 2, paid qtrly
B share Opt C – 4.00% fronted, 0.50% trail, year 2, paid qtrly
B share Opt D – 3.50% fronted, 0.75% trail, year 4, paid qtrly
C share Opt A – 2.00% fronted, 1.00% trail, year 2, paid qtrly
C share Opt B – 1.15% fronted, 1.15% trail, year 2, paid qtrly
L share Opt A – 6.00% fronted, 1.00% trail, year 5, paid qtrly
L share Opt B – 4.00% fronted, 1.00% trail, year 2, paid qtrly
if i give all these in " " quotations getting error? how should i give this long text value?
Do u want to display any one of the line out of 8?
Hi Tillu,
Did you try putting the whole set in TEXT() .
Regards,
Ashish