Skip to Content
0
Former Member
Nov 07, 2007 at 02:53 PM

condition IF in formula of the query!

24 Views

Hi,

I need to define a Key figure which has values calculated depenidng on the logical expression:

if GID-PRD<= 2 and PRD-GID<=5 then counter should add 1 or 0 depending upon the condition success.

now i had written in the formula as follows:

(GID-PRD<=2) + ( PRD-GID<=5) * count( ).

but it is saying general syntax error.

Can any body suggest me whats wrong in what i had coded?

Thanks,

Ravi