Skip to Content
0
Former Member
Jun 25, 2008 at 12:41 PM

Calculated keyfigure

20 Views

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