logic Help

[abhaysingh]

hey Guys,

i have one field Which contain a field AB i want to rename it in Two name in a existing field only,

.i.e. if( field = 'AB', 'AB1' or if (field = 'AB' ,'AB2' ), Field)

is it wrong?

[stabben23]

This logic is fail, you have to decide if AB should be AB1 or AB2 not both.

[#3]

Hey Abhay...

The OR logic itself works in a manner when first condition stands true, it won't go for next condition. So it will not allow you to rename twice using same condition.

[#4]

Could you explain what you want to achieve?

I not understand from your example

[#5]

you can't identify same time one field as 2 different name.

[abhaysingh]

Dear Chandana,

i have one field which contain hundreds of value, from hundreds of value i have one code let say LH, for which i am getting Sales Value, and for that LH Code, client given me two bifurcated target on the basis of Percentage. i.e LH1 contain 55% of total sales and LH2 is 45 % of Total Sales.

Now i want To bifurcate LH in to LH1 and LH2 and Mappe target with actuals.

NOTE- rest all value codes excepect LH should give 100% actuals and Target

thanks