Display Negative Values only

building reports desktopintelligence
1

HI All

im trying to display Negative value for our top 20 declining customer reports have to be automated

i import from data provider customer name , Year & sales

i applied formula to get the value differences as below

=<Sales(Revenue)> Where (<FiscalYear(Revenue)>=“2018”) -<Sales(Revenue)> Where (<FiscalYear(Revenue)>=“2017”)

and also make formula to get the growth as below

=Sum((<Sales(Revenue)> Where (<FiscalYear(Revenue)>=“2018”)-(Sum(( (<Sales(Revenue)> Where (<FiscalYear( Revenue)>=“2017”)))))))/(Sum((<Sales(Revenue)>Where (<FiscalYear(Revenue)>=“2017”))))

i tired to apply Rank with from bottom but its still show some positive value

need to help here

shado26 (BOB member since 2018-10-09)

2

please help here

shado26 (BOB member since 2018-10-09)

3

Moderator note:
Please do not bump your post until at least one business day has passed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)