Exclude dimension value in Management reporter

(0) Share

Report

Posted on by Zlatina Kostadinova...

Hello,

Can I make a formula, where I get all dimension values but for one specific dimension I want to see only the blanks.

The Dimension has 2 values and blank allowed. Most of the transactions will be with the blank value.

So I need on the lines to exclude those values and to have one separate line that is showing only the transactions that have some value.

I've tried to add a Dimension value set that removes the values - like -1; -2 but then the balance for that account is coming 0.00 which is not correct.

What should be done?

I have the same question (0)

All responses (3)

Answers (0)

Zlatina Kostadinova... 86 on at

Like (0)

Report

Meanwhile I think I figured it out but will love to hear your solutions

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

I was not able to setup blank as well. So as a workaround, I used calculation "total minus that has dimension".

Was this reply helpful? Yes No
Zlatina Kostadinova... 86 on at

Like (1)

Report

Thank you! That was exactly what I did as well.

Was this reply helpful? Yes No