5 Replies Latest reply on Jul 16, 2018 4:02 AM by meenu choudhary

# Meaning of calculation field/symbol means

May I know what does the calculation field below mean? There of the calculation fields are linked.

1. Max Date

{ FIXED :MAX([Date])}

2. Sales Cal

IF [Date] = [Max Date] THEN

[Sales]

END

3.

SUM([Sales Cal])

/

SUM(IF [Date]<>[Max Date] THEN [Sales] END)

-1

Thanks

• ###### 1. Re: Meaning of calculation field/symbol means

Hi Haan,

The above logic is explain as below:

1. Finding the maximum(or latest) date from the data set.

2. Sales for the latest date.

3. calculating percentage of latest sales by total sales.

• ###### 2. Re: Meaning of calculation field/symbol means

Dear Meenu

Thanks!

[Date] = [Search Date] or [Date]={ max(If [Date] < [Search Date] then [Date] end)}

Search Date is the parameter...

• ###### 3. Re: Meaning of calculation field/symbol means

So,

The date has to be equal to "search date"

OR

When Date is less than "search Date" then max of date.

• ###### 4. Re: Meaning of calculation field/symbol means

Dear Meenu

Thanks once again!

• ###### 5. Re: Meaning of calculation field/symbol means

Most Welcome Haan.

Happy to help