-
1. Re: Calculations
Tom WNov 30, 2016 4:53 AM (in response to Tulu Sahoo)
Hi Tulu,
You could create a calculation like IF [MyField] is null then 1 else [MyField] END.
If this doesn't solve your problem please upload a Tableau Packaged Workbook including some sample data and provide more detail around what you're trying to calculate.
-
2. Re: Calculations
Tulu Sahoo Nov 30, 2016 4:56 AM (in response to Tulu Sahoo)Sorry Friend, It is not working.
-
-
4. Re: Calculations
Tom WNov 30, 2016 5:16 AM (in response to Tulu Sahoo)
Create a calculated field to determine the maximum blank period. MaxBlank= {FIXED Region : MAX(IF ZN([Sales]) = 0 then Year END )}
This field uses a Level of Detail calculation.
Then setup a field to determine the sales based on the MaxBlank item. IfSales=SUM(IF Year>=[MaxBlank] then [Sales] end)
Use this field in your report.
-
5. Re: Calculations
Tulu Sahoo Nov 30, 2016 11:08 PM (in response to Tom W)Hi Tom,
Thanks for your reply, By using these calculations all the values are coming blank.
Kindly provide some other solution.
Tom----> We have to create one calculated field which will scan every row for the Null, once it will get , from that position onwards till last will be replace as null but behind that position values should keep as previous value.
Thanks.
-
6. Re: Calculations
Tulu Sahoo Dec 1, 2016 12:52 AM (in response to Tulu Sahoo)1 of 1 people found this helpfulHi Friends,
I have developed one workaround solution for my problem. You can use below calculations to achieved this solution.
IF INDEX()>WINDOW_MIN(if isnull([Measure]) then INDEX()) then Null else [Measure] end
Thanks for your support.