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]

Hahahah.... Good job sunny boy....

can you paste a screenshot of both your expressions?

[Anonymous]

Haa no worries Sunny. Appreciate the help..

=If(not IsNull([Margin]), (pricing_oplistm_price) - (pricing_oplistm_price/100)*pricing_price_deal_discount)

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

[sunny_talwar]

Jamel Messaoud‌ not asking to copy paste the expression, but paste a screenshot of them from the application

[Anonymous]

Sorry Sunny.  Screenshot below

[sunny_talwar]

Hahahaha looking for the screenshot of the expression in the Edit Expression window like below

Sorry, if I was not clear before

Best,

Sunny

[Anonymous]

Sorry Sunny.  What I was being stupid! Haha.

You'll be glad to know I have figured this out now! Hurray...

Thank you very much for your help it is much appreciated

[sunny_talwar]

Awesome

I am glad you did, but would you be willing to share what were you doing wrong? May be someone else might benefit (in the future) from your response and won't make the same mistake

Best,

Sunny

[Anonymous]

Hi Sunny,

I fixed this by adding one of my expressions as a dimension within the table.  I was then able to suppress zero values on the table and this removed the unwanted date

Thanks again for your help.  Wouldn't have been able to achieve this without this community