1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
0
The Field you are trying to create is meant to be a numeric field but in the else branch you use a string.
To make your calculated field work , you need either to set a numeric value in the else or cast the measure to a string.
ifelse({Forecasted Monthly Revenue}>0,toString({Forecasted Monthly Revenue}),"NA")
But I do not really think you want that. Can you try to explain what you would like to achieve?
How would you show the field in a visual?
are you not interested in aggregating the value by dimensions?
Hope this helps,
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
The measure I am trying to create is an estimate for projecting business performance for a future time period. Occasionally the estimate will be 0 or yield a div/0 error and in that case, I was hoping to simply have the KPI visual show "NA".
Upon reading the docs more closely, I see that the then-expression and else-expression must have the same data type...but still I was hoping for some way to handle this situation where I show "NA" if the estimate is <0