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