Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to restrict the dimension based on the outcome of a Expression.
For example:
Account ID Member ID Program Name Projected Cost Actual Cost Variance (Projected - Actual)
100 1000 ABC 1000.00 1000.00 0.00
200 2000 XYZ 2000.00 1000.00 1000.00
In the above scenario all the second record should be visible to the user as it has variance. rest all with 0 variance should be hidden from the table.
Thanks,
H
--Please look at the file attached for better visibilty of the question--
On the chart properties go to the “presentation” tab and select “Suppress Zero Values”
try this
aggregation function ({<variance={'>0'}>} variance)
Perhaps this will work:
Projected cost = sum(if(variance >0, [Projected Cost]))
Actual cost = sum(if(variance >0, [Actual Cost]))
Another option avoiding an if could be:
Projected cost = sum({<variance = {'>0'}>} [Projected Cost]))
Actual cost = sum({<variance = {'>0'}>} [Actual Cost]))
Hope one of these methods help.
Best,
Matt
Did any of the options above work for you?
Matt
Hi,
Try to keep the Project Cost and Actual Cost in the Dimension .
Just Keep ProjectCost - Actual Cost (Variance) in the Expression .
So it will automatically hide when the Expression ( Variance values ) is Zero .
Thanks
Please let me know for the same .