Skip to Content
0
Former Member
Apr 19, 2012 at 12:49 AM

Urgent Desktop Intelligence Formula

48 Views

Deski Formula :

=Count(<Name(Parameters)>) Where (<Not NULL Variable> = 0)+NumberOfRows(DataProvider(<Value(Long Memo)>))

In Deski ,For this formula iam getting a correct count ex: as there are 2 entries so iam getting count result as 2 .

where as in Webi :

=Count([Parameters].[Name]) Where ([Not NULL Variable] = 0)+NumberOfRows(DataProvider([Long Memo].[Value]))

it is displaying count as 0 .instead of 2 .

Please let me know what need to be done.