Search code examples
crystal-reportscrystal-reports-xi

Multiple if in 1 formula

new user here.

can anyone show me how to get this to work in 1 formula ? thx in advance.

Paul.

(if {TASKS.PRIORITY} = "1- Delivery stop" then "4"); or 
(if {TASKS.PRIORITY} = "2- Functional Some proces stop" then "12"); or
(if {TASKS.PRIORITY} = "2 - High" then "12"); or
(if {TASKS.PRIORITY} = "2- Technical Some proces stop" then "8")
Solution

  • Try this way

    if {TASKS.PRIORITY} = "1- Delivery stop" 
then "4"
Else if {TASKS.PRIORITY} = "2- Functional Some proces stop" 
then "12"
Else if {TASKS.PRIORITY} = "2 - High" 
then "12"
Else if {TASKS.PRIORITY} = "2- Technical Some proces stop" 
then "8"