Filter to show only rows above a certain %

[Anonymous]

See attached table - the % Disc is a calculation using (original retail price - price sold/original retail price). I want to implement a filter to show only % Disc above 40%.

Can that be done? If yes, how?

Thanks for your help.

Amit

[YoussefBelloum]

Hi,

do you want to filter the data on the script or on a chart ?

if you want to do it on a chart, what type of chart you are going to use ?

[surendraj · Accepted solution]

May be this!!

if((original retail price - price sold/original retail price)>' 40%','%Disc')

if it was pre-caliculated then we can write the expression as

if(%disc > ' 40%','%Disc')

[Anonymous]

Thank you. I like the pre-calculated idea on the loading script. This works out fine when I do it this way.

[surendraj]

% Disc is field.so we no need to enclose this in single quotes..

if(%disc > ' 40%',%Disc)