expression issue

[krish2459]

Hi ,

I'm using the below expresiion but I don't get any values plotted in the chart.

=if($(vRepeat _Flag) = 'Yes' and [Repeat Flag] ='Yes' and

sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> Amount) < '-1000',
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main]))

where 

vRepeat _Flag = if([Repeat Flag]='Yes' and (alt(1-(fabs(sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> Amount))
/
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main])*100),0) < '0.99'),'Yes','No')

Please provide any suggestions.

Thanks,

Krish

[Dalton_Ruer]

$(vRepeat _Flag) = 'Yes'????    ---- From your explanation of  how you defined vRepeat_Flag it will always result in some decimal value and never in the word YES.