I'm using variables to enable me to reuse complex calculations that include set analysis throughout a document. Everything works fine on the desktop application however when view the document through the web the calculations return a value of zero in some cases.
Here is an example of the variables and the equation behind it.
Equation returning zero result on web but not on desktop application: $(vPYGrossValueShipLocal)
Variable definition:
if(
GetSelectedCount([Ship Year]) > 0,
if(GetSelectedCount([Order Price Year]) > 0,
sum({$<[Ship Year] = {$(=max([Ship Year]) - 1)}, [Order Price Year] = {$(=max([Order Price Year]) - 1)}>}
[Gross Value Shipped Local]),
sum({$<[Ship Year] = {$(=max([Ship Year]) - 1)}>}
[Gross Value Shipped Local])
),
if(GetSelectedCount([Order Price Year]) > 0,
sum({$<[Order Price Year] = {$(=max([Order Price Year]) - 1)}>}
[Gross Value Shipped Local])))
Thanks for any help
