BusinessObjects Board

Count([Variance] Where [Variance]>1000 doesn't work

other Xcelsius - Crystal Dashboard Design
#1

Hi Guru,

I created a WEBI table Project Orgn, Value1, Value2, the fourth column is measure name [Variance] = Value2 - Value1. For counting of [Variance] within the table such as Count([Variance] Where [Variance]>1000, it displays correctly, but if I put the formulae outside the table, i.e. in a standalone empty cell, it display as 1.

seowkian (BOB member since 2010-10-26)

#2

Read up about “Webi Calculation Contexts”, either on here or Google.

Mak 1 :uk: (BOB member since 2005-01-06)

#3

thanks mak, managed to resolve by adding ForEach ([dimension]) behind where condition, looks like using In ([dimension]) also works

Cheers !!!

seowkian (BOB member since 2010-10-26)