Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to use logical formula while preparing cash flow?

Microsoft Excel
user-image
Question added by Ghazanfar Ali , Budgeting and Financial Projection Analyst , VNL Steel Export Inc.
Date Posted: 2015/04/10
Upvote (0) Views (7) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
shahid amin
by shahid amin , Computer Analyst , Assistant Commissioner Development

using Script logic will be the best way. But if we  want to go with simple dimension logic...then 

 

>[[NETAR]]-(][NETAR]],[[TIME]].PrevMember)     

 

(no square brackets for Prevmember as it is MDX command, not dimension/dimension member) 

 

can be used to get the difference between this month and last month. 

 

Previous month returns previous member in the level that contains a specific member.

Write Your Answer
More Questions Like This