6 Replies Latest reply on Jun 27, 2016 1:28 PM by Saurabh Siroya

# trouble with date calculations

Hi ,

My latest scenario

I trying to count selected period no of invoice..... where my no of invoice is calculated as---COUNTD(STR(STR([Calc Date])+STR([Customer])))

In my sheet1 i have calculated the selected period Invoice as below and plotted it in a time graph

if attr(DATEDIFF('month',[Calc Date],[start]))<=0 and attr(DATEDIFF('month',[Calc Date],[End]))>=0 then [No of Invoice] END

[Calc Date]e --my date field .........[start] and [End] parameters where customers can choose the period

When I want to see the same as a grid along customer the values are not appearing ...What am I doing wrong Also attached the workbook.

• ###### 1. Re: trouble with date calculations

Hi Keethana,

In sheet2 no values displayed because the date calculated field differs from original date field. We can fix this problem by adding the month(month(date)) in level of detail.

1 of 1 people found this helpful
• ###### 2. Re: trouble with date calculations

But i need the agg value to be displayed  ie.. Customer Name ABC 4 instead of 1 1 1 1

• ###### 3. Re: trouble with date calculations

1 of 1 people found this helpful
• ###### 4. Re: trouble with date calculations

Hi Keerthana,

I have updated the workbook based on your workbook. Windows_SUM will be used to aggregate the original outcome of the result. Here value appears as 4 4 4 4 because the Month field splits the original result. If it wants to be still "4" you can use the else option in the calculated field.

2 of 2 people found this helpful
• ###### 5. Re: trouble with date calculations

Hello,

I have a business requirement where I want to use the relative filter but the current date should be a user input and based on that I should be able to select Weekly, Monthly and Quarterly view. Or is there a way to create a date as an input for the user and based on that I will have a list from which I can select weekly, Monthly or a Quarterly view.

Regards:

Saurabh Siroya

• ###### 6. Re: trouble with date calculations

Hello,

I have a business requirement where I want to use the relative filter but the current date should be a user input and based on that I should be able to select Weekly, Monthly and Quarterly view. Or is there a way to create a date as an input for the user and based on that I will have a list from which I can select weekly, Monthly or a Quarterly view.