Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
I have a table in my app that contains a few dimensions and 3 measures.
The 3 measures are:
1. Current Period - Represents the amount of money I currently have (based on period selection)
2. Compared Period - Represents the amount of money I had in a selected period (also based on period selection, using a different variable than the one used in current period)
3. Difference - the calculation of money in my current period minus the money in the compared period
Also, I have a variable that gets a number that is used as a threshold for amounts of money (we'll call it $Threshhold).
I'm trying to filter rows from the table based on the next condition:
If the absolute value of the difference between the periods is greater than $Threshold, then keep the value of it in the table, otherwise filter it.
The problem is that I can't find a way to actually filter the values from the table, the become a null value instead.
I tried many IF conditions and also tried using the limitation option in one of the dimensions, but to no avail.
I would really appreciate if someone could help me with this.
(And sorry I cant ease it with real examples).
Thanks!