Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
maybe this:
(
sum( {< SALEYEAR = {'2019'} >} NETAMT )
-
sum( {< SALEYEAR = {'2018'} >} NETAMT )
)
/
sum( {< SALEYEAR = {'2018'} >} NETAMT )
maybe this:
(
sum( {< SALEYEAR = {'2019'} >} NETAMT )
-
sum( {< SALEYEAR = {'2018'} >} NETAMT )
)
/
sum( {< SALEYEAR = {'2018'} >} NETAMT )