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