Enterprise & Sell

Enterprise & Sell Answers & Best Practices Calculated field on decimal field for text

Click here to join this group and curate your SugarClub experience.

Details about this thread

State Suggested Answer
+1 person also asked this people also asked this
Replies 3 replies
Answers 2 answers
Subscribers 325 subscribers
Views 127 views
Users 0 members are here

Related content from around SugarClub

Calculated field on decimal field for text

Peter Rupp 5 days ago

I would like to create a new calculated textfield field based on business_hours field (decimal type) that returns a value of "Met" or "Missed"

for when the business_hours field is not empty

based on

if the field CaseType = RFQ and business_hours is less than or equal to 4 hours

or

if the CaseType is equal to (RFI or NCO or ORD) and business_hours is less than or equal to 8 hours

"Met"

Else

"Missed"

0 André Lopes 5 days ago

Hi Peter Rupp

This is the sugarLogic formula

ifElse(and(isInList($type,createList("RFI","NCO","ORD")),greaterThan(9,$business_hours),greaterThan($business_hours,0)),"Met","Missed")

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Vincent Amari 4 days ago

hi Peter

Try the following SugarLogic formula:

ifElse(
and(
not(equal($business_hours, "")),
or(
and(
equal($CaseType, "RFQ"),
lessThanOrEqual($business_hours, 4)
),
and(
or(
equal($CaseType, "RFI"),
equal($CaseType, "NCO"),
equal($CaseType, "ORD")
),
lessThanOrEqual($business_hours, 8)
)
)
),
"Met",
"Missed"
)

Let me know if your CaseType field is a dropdown or a related field — if it's a related field, the formula may need adjustments.

.

CRM Business Consultant
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Peter Rupp 3 days ago in reply to Vincent Amari

CaseType is a dropdown field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel