Switch statement in Indicator field

Advertisement
Switch(([Baseline Cost] - [Actual Cost])/[Baseline Cost] *100 >, "1",
 ([Baseline Cost]  - [Actual Cost])/[Baseline Cost] *100 >10 and ([Baseline Cost]  - [Actual Cost])/[Baseline Cost] *100 <20,"2"))
I have set indicator 1 as green and 2 as red nothing working
Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS
Advertisement

Replay

Thus this should work:
Switch(
( [Baseline Cost] - [Actual Cost] ) / [Baseline Cost]  * 100  <
20 , 1,
( [Baseline Cost] - [Actual Cost] ) / [Baseline Cost]  * 100  >
10 , 2,
True, 3
Hope this helps,
Guillaume Rouyre, MBA, MVP, P-Seller |

Problems with switch statement

He everyone, i tried to built a page with 4 buttons. Each button is a symbol that contains 2 png´2 which are the the button Designs. If you click on  button 1 it should move on the screen. If you click it again it should moves back. and if you click

Redetermine pricing while changing order header usage indicator field.

Hi all experts, we have requirement that user will enter Usage indicator field at header of sales order. We need to copy that to all line item and on bases of this we have to determin price. so in which user exit i shoul copy header value to line ite

XML mapping inheritance problem; missing class indicator field

Hi! I am currently working on a project which involves mapping a large domain model on a XSD schema. For this we use Toplink 10.1.3.1 which is mostly great. But now I have a problem while wanting to use class inheritance. In my XSD I have the followi

Newbie question about switch statement

Lets say you have a loop and inside the loop you have a switch statement, how do you BREAK out of the outer loop? for (i=0....) { switch { case 11: .... some stuff break; <==== HOW DO I BREAK OUT OF THE for loop here?In standard C and standard C++ th

Switch Statement assistance

I have to write a program that uses the switch statement and asks the user to select one of three TV models. The programs provides a description of the models. Use the switch statement, display the model chosen, the description and the price.The user

Java Program.. HELP  (switch statement)

I need help on fixing this program for school.ive looked at information online but i still do not see what i am doing wrong. The College Rewards Program is based on a student�s achievements on the ACT Test. Students that have excelled on the test are

Enum class not supported for switch() statement in 12.4 beta?

Hi fellow 12.4 beta testers, It would appear "enum class" isn't supported for switch() statements in the 12.4 beta. This compiles fine under clang and g++. Will this be fixed for the final release? This currently causes compile errors for us, si

"switch" statement example

Does anyone know of a working example of a "switch" statement on any site?class DoThatSwitch { public static void doTheSwitchThingy(int value)          switch(value)                case 0: {System.err.println("WO!");                   

Unknown state or association field with @Transformation

I have a class that uses a Transformation mapping for the IP address field. The IP address is the string dot notation in the class, but is a long integer in the database. My entity class looks like this: @Entity @Table(name="LOCATION_MAP") publi

Trouble with  instantiating inherited classes in a switch statement

Hi I have few inherited classes which I need to instantiate in a switch statement based on command line argument supplied by user. I am ble to do that but I cannot access any methods once I come out of the switch scope. Please suggest a way to resolv

Question about "switch" statement

hi all I am new to Java programming.. I have one problem that is I would like to use switch statement like below in the switch statement can we use only integers ? but i am using string it is not supporting .. for strings like below what I have to do

Switch statement help please

I have been advised on this forum that a switch statement in place of the if else etc would be neater. Could someone tell me where the switch statement goes in the code below. Thanks Calculator class Calculator.java class Calculator { public void Cal

Case Statement @ Switch Statement

wondering if there are any way i could write this code in case/switch statement @ other way since my program consists a lot of if/else statement public int getLinks() {           int i = 0;           if (n)                i++;           if (e)       

Better switch statement

Hi, with all the changes coming to Java, I'm curious why not enhance the switch statement, allowing the cases to test for ranges, like it's done in basic. Doesn't something like the following switch(x) { case 1 to 7: // do smth case 8 to 12: // do sm

Continue in a switch statement

What is the difference between using unlabelled continue and break in a switch statement? Looks like there is the same effect but I didn't found anything about using continue in switch in any documentation. Here's a typical explanation of using switc

Default case not working in a switch statement

I get a run-time error when i input other flavor than the three listed in the code. Any comments and suggestions are welcomed. import java.util.Scanner; public class EnumSwitchDemo      enum Flavor {VANILLA, CHOCOLATE, STRAWBERRY};      public static

HT5392 How can I use an Action List to re-order my layers in iAd Producer?  It looks like there's a tool for this, but I can't figure out how to use it.  I want to use a button to switch between a text field and a drawing pad layer.

I am working on an iBooks Author Widget and want to allow the user to switch between drawing-pad functions and a text field on screen.  I'd like to create an action that will automatically re-order the layers so that the text field is accessible when

Update statement with many fields

Hi, I am writing an update statement, in a php page, that is formed by many fields, about 80 fields and I would not specify all the fields, does it exist a way to write the update statement without specify all the fields of the record? (I want update

Sorting techinque without using sort statement /Comparing table fields.

Hi, How to achieve sorting techinque without using sort statement in tables. Also how to compare fields of 2 custom tables and check their compatability without using code ?Hi, Refer the below program, it will be helpful. types: begin of t_int,