If statement

[alanwong1178]

Hi all,

I am thinking about using if statement but not working for scenario below:

For example

if condition fulfilled , then use greater than or equal to 0 

if condition not fulfilled, then smaller than 0

if (1=1 ,  ">=0,"<0")

because i am doing another if statement outside this blanket.

like  if ( product sales  if (1=1 ,  ">=0,"<0") ,'a','b')

[Gysbert_Wassenaar]

What are you trying to calculate?

1=1 is always true. That makes the if statement useless.

You use double quotes: ">=0," ... I'm pretty sure you do not have a field in your data model called ">=0,"

If you meant to use a string the use single quotes: '>=0,' ... And you probably misplaced the comma: '>=0', '<0' instead of ">=0,"<0"

product sales are two words. If you meant a field called product sales then put double quotes around it: "product sales" of square brackets: [product sales]

Once you've changed that you get if( [product sales] if(1=1,'>=0','<0'), 'a','b') which totally doesn't make sense because [product sales] if(1=1,'>=0','<0') isn't an expression that can return true or false. I have no idea what you want to happen here. Can you explain?