Hi,
I have 3 Pivot calculated field formaul's as below:
=('Total SL'+'Total UL')/'Expected Man Days'
='Total SL'/'Expected Man Days'
='Total UL'/'Actual Man Days'
Result in pivot table is showing #DIV/0! error. Because some of the reference field data is zero.How can i make error to show as 0 if the result of above formula is#DIV/0!.
Screenshot if attached...
Could you please help me.
Thanks in advance!!!
Capture.JPG
Last edited by vinayjan; 08-31-2013 at 04:34 PM.
Have you tried for wrap this formula in IFERROR?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks