Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
My data set contains an amount field, with both positive and negative amounts. I would like to be able to filter my dashboard on all positive amounts and I don't want to have to click on all the positive amounts in the listbox. I was thinking the easiest way would be to create a Positive/Negative indicator field that would mark all positive amounts as "Positive" and all negative amounts as "Negative". How would I go about doing that? Is there a better way to filter on all positive or all negative values?
In the list box, you can create an expression:
If the dimension is greater than 0, then dimension. In this way, you are only pulling the positive numbers.
Hope this helps
use a listbox where you can select your positive values with ">0"
what you mentioned by a indicator field would be created in script by
if value>0,'pos','neg') as Indicator
create buttons with search in field actions.
hope this helps
regards
Marco
Just type ">0" into your listbox
Hi,
one example for selection buttons and an additional field created in the load script:
tabAmounts:
LOAD *,
Pick(Sign(amount)+2,'negative','zero','positive') as [amount sign];
LOAD RecNo() as ID,
Round(Rand()*40-20) as amount
AutoGenerate 30;
hope this helps
regards
Marco