Hello guys! I need help.
I have a data worksheet that does not notify zero for null values.
When I put in the expression to bring in the value of the last month, it returns the value of the preceding month.
I need zero to appear.
Can anyone help?
in a text box does not bring back the requested month ID?
Or how are the PerID and [natureza jurídica] fields related in your data model, where do you see the NULL?
Could you post some sample records?
Max (PerID) returns yes the last month. The problem is that in the data table that I do not appear the field information without occurrence of values.
Sales in the month of October / 17:
As seller B did not make sales in the month of October / 17, it does not appear in the table.
So what's the contex of your expression? A table chart with dimension Seller? And any active selections?
Are you talking about seeing the september sales for seller B in your sample instead of october sales, as seen for seller A.C.D?
From what i understand you have null values in the Salesman field and you want the null values to be changed to 0.
you can do that in script with alt(Salesman,0) as Salesman
Hope it helps,