Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a report that returns a "hyphen" when there isn't any data in that timeframe.
My question would be, what does the Hyphen equal when I am composing a formula within an if statement?
They are nulls for that given value...
Ex:
If you have 5 dimensions and 1 measure, sometimes few of the rows will not show value for your measures but would show '-' as one of the dimensions in that table has value
hyphen represents null values.
You can find it with functions like isnull(), len(trim()), or simply comparing like: if(field = "",...
Can your please share your If condition?
And, also confirm your field names are properly spelled in the condition.
=if(num(sum($(Transaction_vSetYTD) $(vProfit_True))/sum($(Transaction_vSetYTD)$(vSales)),'#,##0.0%')='','No',Yes')
what's the output that you're getting from the above expression? Is that a hyphen?
what does the below expressions give you
-> sum($(Transaction_vSetYTD) $(vProfit_True))
-> sum($(Transaction_vSetYTD)$(vSales))
If the above expressions are always giving you some values, then the output of your expression is always 'YES'.
Seems, You expression not returning Null values, Try this way?
=if(IsNull(num(sum($(Transaction_vSetYTD) $(vProfit_True))/sum($(Transaction_vSetYTD)$(vSales)),'#,##0.0%')),'No',Yes')
I appreciate your suggestion, but that doesn't work. it doesn't show a null value, just the hyphen
It doesn't always have a value. First column is CY , second column is PY. If no sales were in the CY or PY , it returns the "Hyphen"
what is your dimension here in this chart?