how to write analysis

[#1]

Hi Friends,

How to write set analysis for between 3 months data ,

what is diff b/w  today() and today()-1 it get number or date.

interview questions?

[ramasaisaksoft]

Hi Siva,

2nd answer is Number only .

[Anil_Babu_Samineni]

Hope helps

1) Sum({<Month = {"$(=AddMonths(Month, -3))"}>}Sales)

This Will give last 3 months of Sales

2) Today() Will give Today's date of your Computer calendar & Today()-1 is Yesterdays date of your computer calendar (It returns Date for Today and Number for Today-1)

[Anonymous]

hi,

today() is going to print today date like 30-11-2016

today()-1 is going to print number,if you apply date(today()-1) it will brings the yesterday date.

[Anonymous]

It will helps you to get 3 months data

sum({<Your Date filed={">=$(=AddMonths(Today(),-3)) <=$(=Today())"}>}Sales)

this expression brings data from 3 months back to today.

[MindaugasBacius]

It'll calculate the sum of Hours where Data > 2016-08-30:

=SUM(

{<

  Date={">$(=Date(AddMonths(today(),-3), 'DD/MM/YYYY'))"}

>}

Hour)

The date is a dual functions. It contains numeric and date values.

[#7]

Thanks Anil for your quick replay,

Could you help me on set analysis , i have lot of doubts , if you have time