Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

Cannot remove decimal places

Hi,   This is driving me mad, hope someone can help! The code below defaults the Average Months to 2 decimal places - I don't want any decimals.   Case Length (Adj) Mths = IF ( 'Cases'[sta...
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    ArchStanton 

    Measure = FORMAT(SUM(Table[Case Length (Adj) Mths]),"##")



ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

Case Length (Adj) Mths is a calculated column not a measure

 

It was initially calculating DAYS but I created a copy and changed the Parameter to MONTH earlier today

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

ArchStanton 

Measure = FORMAT(SUM(Table[Case Length (Adj) Mths]),"##")



  • ArchStanton's avatar
    ArchStanton
    Power Participant
    2 years ago

    Hi,

    Thanks for helping me with this.

    It didn't work initially because the Calculated Column is summarised as an Average.

    I removed this from the column, substituted SUM for AVERASGE and it now works with no decimal places ğŸ˜Š

    It's incredible that so much effort and resource is required to do a simple thing like this - maybe its something for the ideas board?!

     

    Thanks for your help!