Urgent Desktop Intelligence Formula

[Former Member]

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.

[Former Member]

Hi Vidya,

Have you tried splitting the formula to understand which component is not returning the right result?

I would create a couple cells with the following formulae:

=NumberOfRows(DataProvider([Long Memo].[Value]))

=Count([Parameters].[Name])

and see if they returns the expected counts to begin with.

Your syntax seems to be valid, although perhaps try with a different object than [LongMemo].[value] to return the name of the dataprovider.

You can also try hard coding the dataprovider name directly as a test: NumberOfRows([my dataprovider])