
1. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 18, 2016 7:28 AM (in response to Jonathan Velarde)hi Shawn Wallwork.., thanks for the feedback..
But upon doing this, the row still on the worksheet. The header only hides.
Regards
Jonathan B. Velarde

2. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 18, 2016 11:28 PM (in response to Jonathan Velarde)Good Day!
Hi Shawn Wallwork.., thanks for this..,
For the sample workbook, we have a creadential for this. I will just create new sample workbook using a superstore data for your visualization.
Will look also on your suggestions..
Regards,
Jonathan B. Velarde

3. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 19, 2016 1:09 AM (in response to Jonathan Velarde)Good Day!
Hi Shawn Wallwork..,
Please check attached file for the sample workbook.
Based on the sample worksheet, the number of days were working fine if I include the Order date on the display.
But when I remove the Order date you will see the difference between the two workbook.
I expect that same figure should display. My Subtotal was incorrect also.
Thanks in advance for the help on this.
Regards,
Jonathan B. Velarde

4. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 19, 2016 1:19 AM (in response to Jonathan Velarde)Good Day!
Please check attached sample workbook.
Thanks,
Jonathan B. Velarde

Sample for forum.twb 93.8 KB


5. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Amanjot Klair Feb 19, 2016 1:33 AM (in response to Jonathan Velarde)Jonathan,
Can you please post a packaged workbook. There is not source data in the workbook so we can't really see the view.
Regards
Amanjot

6. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 19, 2016 2:48 AM (in response to Amanjot Klair)Good Day!
Hi Amanjot Klair.., thanks for looking into this.,
Please check attached sample workbook.
Looking forward for much better understanding on this.
Thanks in advance.
Regards,
Jonathan B. Velarde

Sample for forum.twb 93.8 KB


7. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 19, 2016 7:46 AM (in response to Jonathan Velarde)Good Day!
Hi Mam/Sir..,
Please help on this..,
I want to create an internal calculated field that will compute the number of days between two different dates without displaying the dates per day (Aggregated value) and compute the Total Amount per Number of days range.
Please see sample workbook attached.
Kindly check also the excel file., As I export the data from the the sample workbook I created. On the right side of the exported data I created the sample output I want to display.
Would appreciate if someone could help on this.
Thanks in advance.
Regards,
Jonathan B. Velarde

Sample Output  Forum.xls 26.5 KB

Sample for forum.twb 93.8 KB


8. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Amanjot Klair Feb 22, 2016 12:44 AM (in response to Jonathan Velarde)1 of 1 people found this helpfulCreate a cacl fields for each of the ouput field like the below. This should solve your problem.
[PD <= 60] = SUM({FIXED [Order Date] : MAX(DATEDIFF('day',[Order Date],TODAY()))})

9. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 22, 2016 12:51 AM (in response to Amanjot Klair)Good Day!
Thanks for the feedback.,
I tried datediff for the computation of number of days DATEDIFF('day', TODAY() ,[Due Date] )*1. instead of aggregate using this calculation ZN(INT(ATTR([Date])LOOKUP(ATTR([Date]),1)))
This is much simple to my previous calculation. I guess the previous calculation was too complicated.
Thanks and God Bless
Regards,
Jonathan B. Velarde

10. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Amanjot Klair Feb 22, 2016 1:04 AM (in response to Jonathan Velarde)Or else you may also calculate the datediff at the row level and then aggregate the max of datediff in fixed.
DateDiff = DATEDIFF('day',[Order Date],TODAY())
[<=60] = IF [DateDiff] <= 60 THEN [DateDiff] ELSE 0 END
[PD <= 60] = SUM({FIXED : MAX([<=60])}
this is a little complicated method and i am not sure if this can be nested as well... Just try this one it'll help you cagegorise as per datediff.
Amanjot

11. Re: Calculation of two different dates  Getting Number of days without displaying the actual dates
Jonathan Velarde Feb 22, 2016 1:09 AM (in response to Amanjot Klair)Good Day!
Hi Sir Amanjot Klair..,
Yes that would be helpful..
for your DateDiff calculation it shows negative value of number of days, that's why I multiply it on 1 to get the right value of number of days.
Thanks a lot for looking into this.
Regards
Jonathan B. Velarde