Grazia Palmisano Posted December 2, 2020 Share Posted December 2, 2020 Hi all, I have a text area with some KPI calculate as ratio: NUM/DENOM. In properties Data I have the limiting by some markings.When a marking is selected it affected in the some way NUM and DENOM. is there a way to make the marking filter only NUM and NOT DENOM I don't know ... for example using datatable different ...a way... Link to comment Share on other sites More sharing options...
Fabian Duerr Posted December 2, 2020 Share Posted December 2, 2020 You could add a calculated column that holds for example the total or average value of DENOM. In your calculation for your marked rows you could then use this column instead of DENOM. But since I'm not so sure if I understand your goal correctly I want to ask you to provide some data here with expected result. Link to comment Share on other sites More sharing options...
Neeraj Khatri Posted December 2, 2020 Share Posted December 2, 2020 Yes, this should be possible. If Denom is a static value that doest change, it can be stored in a document property and used in the text area kpi. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now