3 Replies Latest reply on May 17, 2018 4:23 AM by Rajesh L M

# Calculation Logic

Hi All,

i have a below requirement, tried few logic but its not working.

workbook is attached

Requirement: Need products whose Profit >5% and if profit is > =100% then need only the products whose date>=2017

Thanks,

Rajesh

• ###### 1. Re: Calculation Logic

Hi Rajesh,

Create calculated field [Product Filter]

([Profit %] > 0.05 AND [Profit %] <= 1) OR ([Profit %] > 1 AND YEAR([Date]) >= 2017)

This is a Boolean expression. Place this on the filter shelf and set it to "True"

Hope this helps.

Ossai

• ###### 2. Re: Calculation Logic

Hi Rajesh,

Please see the attached workbook, I've created a calculated field called 'Calculation Logic' where :

IF ([Profit %])>0.05 and [Profit %]<=1

then 'Show'

elseif

([Profit %])>1

and ([Date Part Year]) >=2017

then 'Show'

else 'Hide'

END

I then put this field into the filters shelf and selected 'Show'

Thanks,

Mavis

• ###### 3. Re: Calculation Logic

Both the logic's are same and it's working. Thank you.