Calculated keyfigure

[Former Member]

Hi All,

I have two key figures

X -> Key figure

Y-> Key figure

and a Calculated key figure A

A = X / Y

My requirement is if Y=0 i need to consider it as 1 ie A = X / 1

otherwise if Y have some value A = X / Y itself.

How can i do this in my query.

Thanks in advance,

Binoy

[former_member189638 · Accepted solution]

Create A as a formula Key Fig and use the following calculation. Make use of Boolean Operators for this

(Y == 0) * X/1 + (Y != 0)* (X/Y)

!= Not Equal to

Edited by: Rakesh Pattani on Jun 25, 2008 2:49 PM

[Former Member · Accepted solution]

Hi Rakesh,

Thanx ... Problem solved.... gave full points..

Binoy