Formula Error

[RanjanThammaiah]

Hi All,

Can some one help me with the below calculated column. I am trying to calculate the Total Value by number of months. where there are many rows which doesn't have month number.. which needs to be filled as Blank instead of #Error.

Regards,

Ranjan

[amitchandak · Accepted solution]

@RanjanThammaiah , Either you are creating a measure or total value selected currency is a measure.

Create a new column and use column inside that

Or create a measure and use measure and aggregated columns