[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Percentage increase/decrease formula in a Pivot table

Hi!

This is my current formula that I use in my Pivot table:  =(TY - LY)/ABS(LY)

How should I modify it in order to exclude the negative values from both years (TY & LY)

thanks!
0
Ladkisson
Asked:
Ladkisson
1 Solution
 
Dan CraciunIT ConsultantCommented:
=IF(AND(TY>0, LY>0), (TY - LY)/ABS(LY), "")

This will display nothing if TY or LY are negatives.

HTH,
Dan
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now