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

All responses (2)

Answers (0)

Giorgio Bonacorsi 636 on at

Like (0)

Report

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

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

BillurSamdancioglu 15,811 Most Valuable Professional on at

Like (0)

Report

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

Hi,

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