nested if with only function

[srujanaponnuru]

Hi All,

i have  a formula like below:

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}Segment))))>0

I have requirement like i need only(segment) >0 i a similar way only(product)>0 also i need to include in the same above expression

could u please help me on the same.

[srujanaponnuru]

sorry my formula is as below:

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}Segment)))>0,1,2)

[Chanty4u]

try this

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}Segment)))>0,

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}product)))>0

1,2)

or

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}Segment)))>0 and 

if(Len(trim(only({<source = {'ABC'},metrics = {'XYZ'}>}product)))>0

1,2)

[srujanaponnuru]

no its not working