Above and below function

[khalander]

Hi,

I have data like below.

I have used Above function but values is coming NULL.

Date	second Date	Sales	Calcu
1/26/2016	-	2000	2000
2/1/2016	2/1/2016	-
2/13/2016	-	5000	5000

wherever date is equal to second date i want to apply below condition and i want to show that in calcu.

above(sales)+((Below(sales)-Above(sales))*(secondate-date))/(Below(date)-Above(date))

but values is coming nulls for the above calculation

Please do the needful

[sunny_talwar]

Do you have one dimension or multiple dimensions? May be you need to use Above(TOTAL....) and Below(TOTAL...)

[khalander]

I have 3 dimensions.. Total also is not working

[sunny_talwar]

Would you be able to share a sample?

[khalander]

No Sunny, That is the sample data which i have shared

[sunny_talwar]

okay

[sfatoux72]

It's work fine with TOTAL

=If((Only(Date) - Only([second Date])) = 0,Below(TOTAL Sum(Sales)), sum(Sales))

= Above(TOTAL Sum(Sales))+((Below(TOTAL Sum(Sales))-Above(TOTAL Sum(Sales)))*(Only([second Date])-Only(Date)))/(Below(TOTAL Only(Date))-Above(TOTAL Only(Date)))

See the application in attachment

[khalander]

Hi Sebastien,

Thanks for the reply..

Can you attach the application

[khalander]

Still it is showing null values sebastien

[sfatoux72]

The application was attached ???