How to restrict the values in KPI(Straight Table)

[#1]

Hi ,

I have a straight table having the below KPIs and Dimensions.

My Last KPI Email flag condition is having values  "Flag " and spaces.I want to show only "Flag" values in my chart,dont want to show

spaces.

.

Logic for Email flag condition is:

if([CP Budget]=0,'',if([ResidentDays Budget]=0,'',if([Meals Budget]=0,'',if([CP Actual]>=[CP Budget]*1.15,'Flag',if([CP Actual]<=[CP Budget]*0.85,'Flag',

if([ResidentDays Actual]>=[ResidentDays Budget]*1.15,'Flag',if([ResidentDays Actual]<=[ResidentDays Budget]*0.85,'Flag',

if([Meals Actual]>=[Meals Budget]*1.15,'Flag',if([Meals Actual]<=[Meals Budget]*0.85,'Flag',''))))))))).

Can any one please help on this.

Thanks,

Krishna

[Anil_Babu_Samineni]

Try to create one more column with Column(7)>0 and then check, How this works

[#3]

Hi,

For the column(7), what is the logic i should provide.

I didn't get, can you explain me.

[Anil_Babu_Samineni]

Do you create that logic in script or UI. If it is script then use Flag > 0 or if it is in UI then you can use Expression > 0

or

If(Len(Expression) >0, Expression)

[#5]

Still Some Nulls are coming.