Forum Discussion

Keyla2020's avatar
Keyla2020
New Member
6 years ago

Delta Measure Issues

I created a measure that finds the delta between two values, as shown below, CME Delta = SUM('Milestone Data'[CME Budget])-ABS('ad (2)'[EAC])   The issue I'm having is that it works for some line...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Keyla2020 

 

The column 'CME Budget' and 'EAC' in the screen shot doesn't look like a number column. As the number column will be right aligned as in the last column 'CME Delta'.

 

Can you confirm the columns used in the calculation are number, if not convert them to number and try the formula.

If they are number column try using the below formula instead with an ABS for SUM().

CME Delta = ABS(SUM('Milestone Data'[CME Budget]))-ABS('ad (2)'[EAC])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,
Pranit