1 Answer
- Newest
- Most votes
- Most comments
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,
Relevant content
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
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