Skip to Content
0
Former Member
Apr 11, 2012 at 09:35 PM

Formuale in Webi

21 Views

Iam working on webi report where the formula is

=[Male]+" / "+[Female]+" / "+[Unknown] so for this when there is a data it should dispay for example the value as 50/60 (those are age like that .

If i dont have data then in this column iam getting value as / / which should be just blank nothing should be displayed .

I tried this formula but whats happening is

=If(IsNull([Male])Or IsNull([Female])Or IsNull([Unknown])) Then ""

Else [Male]+" / "+[Female]+" / "+[Unknown]

And also whether we can change dimension in to measures and vice versa