This content has been marked as final. Show 6 replies
I am not sure which member you are trying to write that formula on. It should be on 'Adjusted' member as that is what you want to calculate. I am not sure how your formula got validated - You can try any of these formula or modify your formula on similar lines and it should work.
CASE WHEN ([Raw], [Act])= 0 OR ([Raw], [Fcst]) = 0
IIF ( ([Raw], [Act])= 0 OR ([Raw], [Fcst])= 0 , 0 , [Raw])
Edited by: sunil k on Jan 17, 2013 2:28 PM
Thanks for your reply, I forgot to mention. I was writing this formula on Adjusted member.
now its copying data all from Raw into Adjusted. But its doing that even when my ACT or FCST is '0'.
This is the one that is not working properly.
Well it should work and it should copy RAW to ADJUSTED only if ACT and FCST are both non zero
Did you check that the values are perfect zeros - sometimes your display settings in smart view may make fraction values appear as zero.
Could this be a block create issue? What if you load a "1" to the cell you are trying to calculate to in 'adjusted' and then re-run your script.
John, we donot have blocks concept in ASO cubes, i am trying to write member formula.
Formula is working now, i have replaced '0' with missing.
Thank q for the help. i tried to mark your reply as correct, but its not letting me.