cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kolumam Member
Member

Re: Issue with Calculated column

Hi All,

dadsa.JPGformula.JPG

 

 

 

 

 

 

 

 

 

The existing numbers changed to something else?

 

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

@Kolumam

Have you used the FORMAT formula like this?

 

FORMAT(ColumnName, "")

with double quotes at the end?

Kolumam Member
Member

Re: Issue with Calculated column

Hi 

 

Please find the formula.

 

Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "string")

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

Change it to 

 

Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "")

without the word 'string'

Kolumam Member
Member

Re: Issue with Calculated column

Awesome, Thank you so much.

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

No problem@Kolumam 

 

If the answer provided has fixed your issue please mark is as a solution so as to help other readers as well.

 

Thanks

Kolumam Member
Member

Re: Issue with Calculated column

One last question,

 

Is there anyways to calculate the average totoal for the column if it consits of both NA and number?

Highlighted
Kolumam Member
Member

Re: Issue with Calculated column

Already marked as accept it as solution.

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

@Kolumam

 

There may be a way to do it that but you need to try it yourself.

 

I think you need to write a DAX formulas where 

1. All values in the column will be first converted to numbers (blanks, NAs, NULLs converted to Zeros)

2. Then Put the FORMAT function at the end, which will take all the results (numbers) and convert them to text.

So the DAX will start with FORMAT ( transformation to number  ) and will have the transformation within it.

 

I hope this makes sense?

 

You can give it a try and see if it works

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 147 members 2,278 guests
Please welcome our newest community members: