You should use CASE
sample is this one for Superstore.
case [Category] when "Furniture"
"Do not display"
can you please explain me in when 2=2 case will be executed as per your code?
My view on this is that, it will never get executed.
If 1st condition also satisfied again I have to go 2nd condition.
My both condition should be come. Just I tried 1=1 and 2=2...
IF 1=1 THEN [Expense Type] ELSEIF 2=2 THEN [UN] END
My idea is I should union both values in single dimension.
If 1=1 then [expense Type] end
if 2=2 then [UN] end
I guess Expense Type can be of type string (just guessing). Not sure about the [UN] column. I doubt if "Plus" sign can work in the scenario.
Ok. As per condition 1=1 will always be evaluated as true. Thus 2=2 will never be executed. That's what I wanted to convey about the field.
This will concatenate result.
MY requirement is
Both Field are Text values only.
Are you saying you want one formula to give you 2 values or you want the formula to give you back a combined value with a new line in between
yes. I want to show both values in single query.
A single calculation can not provide you with two outputs.
you can put to fields as one output concatenated or split by line
1 of 1 people found this helpful
If condition can't give more than one value and in this 'IF 1=1 THEN [Expense Type] ELSEIF 2=2 THEN [UN] END'
never execute the elseif condition because 1=1 is true for each and every time.
can you explain your scenario,May be will help you.
Sreenadha Reddy P