Forum Discussion
RanjanThammaiah
4 years agoHelper V
Formula Error
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
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
1 Reply
- amitchandakSuper User
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