PERCENTAGE ON SUM

[PASHA]

Dear Team,

   Hi Greetings to all ,

  I want to do one (a-b)/b formula in my dashboard as a sample.

A   formula is    sum({$<SALEYEAR={"2019"}>}NETAMT)

B  formula is   Sum({$<SALEYEAR={2018}>}NETAMT)  now hoa can i do A-B/B with this

Thanks.

[agigliotti · Accepted solution]

maybe this:
(
sum( {< SALEYEAR = {'2019'} >} NETAMT )
-
sum( {< SALEYEAR = {'2018'} >} NETAMT )
)
/
sum( {< SALEYEAR = {'2018'} >} NETAMT )

[pradosh_thakur · Accepted solution]

(sum({$<SALEYEAR={2019}>}NETAMT) - Sum({$<SALEYEAR={2018}>}NETAMT) )
/ Sum({$<SALEYEAR={2018}>}NETAMT)

couple of things to note
1: it's not a good practice to hard code values
2: DOUBLE QUOTES are used as search string, don't use if not necessary.