Dim data not exists in FACT

Anonymous — Mon, 29 May 2017 13:31:48 GMT

Hi,

1. I have Items Dimenssion and Companies Dimensions.

2. My Expression is 1.

I think because I have no data in the FACT table about the Item name "Ki Net Profit",

I see the 1 amount (from the expression) under null Company.

Any suggestion to solve that?

* When I put data for this item in the FACT I see 1 under the companies Dim, But I want another solution if exist.

* I need a layout solution only.

Thanks

Re: Dim data not exists in FACT

felipedl — Mon, 29 May 2017 14:15:31 GMT

Hi Meitar,

You could try an if statement to check if the Company has value, something like this

(

len(Company) <> 0,

count(Item)

)

Attached is an example QVW.

Regards,

Felipe.