Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I make a simple file with 2 problem in it :
1: change list box value , change text box with absolute formula (TOTAL function)
2:change input box donot change gage formula
please help
1) Change the expression to this
=sum({<Date={2019}>} [sale])/sum({1} sale)
2) Change the expression to this
Sum({<[Date]={"$(v1)"}>} [sale])/sum(TOTAL [sale])