ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (7, 47) The value for column 'EmailsDelivered' in table 'Table1' cannot be determined in the current c

jersey

New Member
Joined
Mar 9, 2012
Messages
28
Hi:) I'm trying to do a simple formula in powerpivot.
In regular excel I'm use to creating the formula Delivery Rate=EmailsDelivered/EmailsSent.
I tried to create this formula in DAX.
=(Table1[EmailsDelivered]/Table1[EmailsSent]) but I got the error saying
ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (7, 47) The value for column 'EmailsDelivered' in table 'Table1' cannot be determined in the current context.

Please help,
Thank you,
Cindy:)
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

powerpivotpro

Board Regular
Joined
Jan 18, 2012
Messages
242
Hi Cindy. Is this in a measure? If so, try SUM(Table1[EmailsDelivered]) / SUM(Table1[EmailsSent])

One of my "golden rules" of measures is "no naked columns."

See this short video for the rest of the golden rules:

http://www.youtube.com/watch?v=29frZhkwCqQ
 

jersey

New Member
Joined
Mar 9, 2012
Messages
28
Hi Rob . sometimes i forget that i am naked. thank you for helping me.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,742
Messages
5,524,566
Members
409,586
Latest member
BonitoWaqar

This Week's Hot Topics

Top