
1. Re: How to use fixed function for a field which is calculated by table calculation
Zhouyi Zhang Jul 5, 2017 6:03 AM (in response to Himanshu Sharma)Hi, Himanshu
Not sure I understand your requirement correctly or not.
Please see my result below
Workbook attached with 10.2.
Hope this could help
ZZ

Position Table_Dummy.twbx 48.4 KB


2. Re: How to use fixed function for a field which is calculated by table calculation
Himanshu Sharma Jul 5, 2017 11:16 PM (in response to Zhouyi Zhang)Hi Zhouyi,
I would like to thank you for your time and consideration.
solution is not seems right. it should be 11 for Plant B001, ProdAB and month Jun'17.
I've make small changes in formula of closing stock and closing status. TWBX is attached with version 10.3.
My requirement: Need to calculate number of days for which closing stock <Minimum Inventory
Please help me to get this.
Solution looks like this. calculated in excel
Plant Prod Jun17 Jul17 Sep17 Oct17 Grand Total B001 AB 11 31 30 31 103 XYZ 0 17 25 31 73 B002 AB 10 29 30 31 100 XYZ 21 0 25 31 77 Grand Total 42 77 110 124 353 Thanks and Regards,
Himanshu
Sum of Closing Status Flag Month Plant Prod Jun17 Jul17 Sep17 Oct17 Grand Total B001 AB 11 31 30 31 103 XYZ 0 17 25 31 73 B002 AB 10 29 30 31 100 XYZ 21 0 25 31 77 Grand Total 42 77 110 124 353 
Position Table_Dummy.twbx 48.0 KB


3. Re: How to use fixed function for a field which is calculated by table calculation
Himanshu Sharma Jul 9, 2017 9:03 PM (in response to Himanshu Sharma)Hi Zhouyi,
I am still waiting for a solution. Please suggest to resolve this...
waiting for a sooner reply.
Regards,
Himanshu

4. Re: How to use fixed function for a field which is calculated by table calculation
Rahul Upadhye Jul 10, 2017 11:08 AM (in response to Himanshu Sharma)1 of 1 people found this helpfulUnfortunately, its not possible yet.
LOD cannot be calculated on top of a Table Calc.
Vote here:
LOD with Table Calc https://community.tableau.com/ideas/6968
LOD with Sets https://community.tableau.com/ideas/7239

5. Re: How to use fixed function for a field which is calculated by table calculation
Rahul Upadhye Jul 10, 2017 11:11 AM (in response to Himanshu Sharma)1 of 1 people found this helpfulHowever your problem can be solved if you move your table calc to be a regular expression.
Then you can create LOD to compute number of days for which closing stock <Minimum Inventory

6. Re: How to use fixed function for a field which is calculated by table calculation
Himanshu Sharma Jul 10, 2017 9:09 PM (in response to Rahul Upadhye)Hi Rahul,
Thanks for the reply..
Calculation of closing stock can not be a regular expression. If you can suggest something than it will be appreciable.
KPIs are given below..
Closing Stock= Opening Stock+ Receipt Consumption
Opening Stock= Prev. Day Closing
Regards,
Himanshu Sharma

7. Re: How to use fixed function for a field which is calculated by table calculation
Zhouyi Zhang Jul 10, 2017 10:13 PM (in response to Himanshu Sharma)Hi, Himanshu
Sorry about the late response.
I tried with the sample workbook, but I can't make every number match to your sample result. please see highlighted below.
Not quite sure is it because the data difference or I am still not git it right. But from the Position Table sheet, it look right.
Workbook attached for your reference. Please let me know if you have question
ZZ

Position Table_Dummy.twbx 49.3 KB


8. Re: How to use fixed function for a field which is calculated by table calculation
Himanshu Sharma Jul 11, 2017 2:49 AM (in response to Zhouyi Zhang)Hi Zhouyi,
Thanks for this..
Please tell me how it is calculating and share steps for this..
Regards,
Himanshu Sharma