Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
$(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.