Financial reporter reporting tree filter - show values where a financial dimension was not used

(0) Share

Report

Posted on by PN004

Hi All,

I've created a financial report where a reporting tree definition uses 3 unique values from a financial dimension called /Location/. I want to add in a 4th value to show transactional amounts posted to a GL code that have not used that Financial dimension. The reporting tree would ideally look like something below:

Company	Unit Name	Unit Description	Dimensions
@ANY	Summary	Summary
@ANY	Loca 01	Location 01	+Location= [01]
@ANY	Loca 02	Location 02	+Location= [02]
@ANY	Loca 03	Location 03	+Location= [03]
@ANY	No Local	No Location	+Location= []

However, no matter what filter I try I can't get the 4th value to return the correct values. Can anyone suggest a fix for this?

cheers,

Paul

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

BillurSamdancioglu 20,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

You may try (All - filled) to see the blanks

Was this reply helpful? Yes No
Giorgio Bonacorsi 1,731 on at

Like (0)

Report
Copy link

Link copied!

Good question. Have you try in this way: @ANY No Local No Location +Location= [""] ?

Was this reply helpful? Yes No