Show records

[Anonymous]

Hi guys,

I have a straight table which I would like to only show records where a field is 5.00 or below

The field is called Margin.

The reason I would like to do this is because when I show all records the table says "object out of memory"

Any help would be appreciated

Thanks

[sunny_talwar]

Replace your existing expression with this may be:

If(YourExpression <= 5, YourExpression)

[Anonymous]

My expression is this! Can you help?

=(([Discounted Price] - [Product Cost]) / [Discounted Price] * 100)

[sunny_talwar · Accepted solution]

Have you tried this:

=If((([Discounted Price] - [Product Cost]) / [Discounted Price] * 100) <= 5, (([Discounted Price] - [Product Cost]) / [Discounted Price] * 100))

[#5]

If((([Discounted Price] - [Product Cost]) / [Discounted Price] * 100)<=5,(([Discounted Price] - [Product Cost]) / [Discounted Price] * 100))

Regards,

KKR

[Anonymous]

Ah that's perfect. Thanks guys.

Can I exclude the values where the Margin is now "-" from my table - I set this to 20 as a test...

[sunny_talwar]

It should have already excluded them. Are there more expressions in this table?

[Anonymous]

Ah yes, I thought that might be the case.  I have one other expression within the table..

[sunny_talwar]

Why don't you restrict the other expression like this:

If(not IsNull([Margin]), yourExpression)

Where Margin is the label of the above expression (Margin should turn blue when you use the above expression)

HTH

Best,

Sunny

[Anonymous]

Hi Sunny

I tried this but it didn't work.. This is my other expression

=If(not IsNull([Margin]), (pricing_oplistm_price) - (pricing_oplistm_price/100)*pricing_price_deal_discount).  It's also broken my margin expression too... Haha