XRL Formula for User Defined Field

Hi all,

I wonder if any one can help me or am i correct in saying that you cant use a Filter on a User Defined Field in XRL.

I have created a straight forward XRL report where Client is looking at Gross Profit and Gross Profit Percentages.

I want to be able to just have a Filter somewhere so that the Client can just concentrate on line items that he is not achieving a high enough GP %.

Does anyone know is there a way to put this filter into XRL ?

Thanks

Dermot

Find more posts tagged with

Pegasus - Partner General Discussions

Accepted answers

All comments

fzw

When I created the Gross Profit % I omitted the x100 to get the percentage and picked Percentage from the Format drop down box. Then on the filter I set to >.90.

Hope this hleps

Felicity

unknown

Thanks Felicity,

Thats works in the Excel Filter.

alison-adam

You can tick the Allow Filtering option in the UDO where you've created the formula and you should then be able to apply the filter in XRL.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help

Copyright © 2025 Infor. All rights reserved.