Calculated Field in Custom Form Looking for your expertise | Community
Skip to main content
Kundanism
Kundanism
Level 10
March 9, 2021
Solved

Calculated Field in Custom Form Looking for your expertise

  • March 9, 2021
  • 1 reply
  • 524 views

Hei

Created Custom form title "Priority Setting of ECRs", but in the calculated field "Priority of Claim" tried to add condition on IF statement.

This calculated field is based upon above calculated field "CC1", and added to a project while testing. But the calculated field "Priority of Claim" does not shows the condition based upon the value coming from calculated field "CC1".

Please guide in this regard. Also refer the attachment.

Mvh

Kundan.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

Hi - so I've never seen <= in a calculated expression. I tend to stick to just equal, less than, or greater than. Based on your screenshot, this is the calculation I would use

IF(CC1=729,"Urgent",IF(CC1<500,IF(CC1<11,"Low","Medium"),"High"))

See if that works for you.

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
March 10, 2021

Hi - so I've never seen <= in a calculated expression. I tend to stick to just equal, less than, or greater than. Based on your screenshot, this is the calculation I would use

IF(CC1=729,"Urgent",IF(CC1<500,IF(CC1<11,"Low","Medium"),"High"))

See if that works for you.

Kundanism
KundanismAuthor
Level 10
March 11, 2021

Many thanks @Anthony Imgrund‚

Really appreciate your help and attention for quick reply.

I confirm, it works exactly.

Have a nice day!

Best regards,

Kundan.

Terms & ConditionsAccessibility statement

Loading footer...