
1. Re: Calculations
Tom W Nov 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 W Nov 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.