Dim data not exists in FACT

[Anonymous]

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

[felipedl]

Hi Meitar,

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

if

(

  len(Company) <> 0,

  count(Item)

)

Attached is an example QVW.

Regards,

Felipe.