Filter on Calculation

[ljames88]

I want to be able to filter on a calc in a table.

For example, I have a project list that shows a gross margins, and I want to setup a filter that will show Gross Margins Greater than 50, between .30 and .49 and less than .30.

How can I do that?

Thanks

[sunny_talwar]

May be create a list box like this:

If(GrossMargin >= 0.50, '>=50%',

If(GrossMargin > 0.50 and GrossMargin < 0.30, '30% - 49%',

If(GrossMargin <= 0.30, '30%')))

[ziadm]

if you have a specific range of GrossMargin use Class function

Load

Class(GrossMargin,10)  as MargingGroup

if you have a variable range of GrossMargin

Then refer to this community blog

Custom Filter(unusual range)