Hi,
Please let me know how to add the below logic into the expression:
Logic:Sum(INVCOUNT)/sum(ESTCUST)
Expression:
if(GetcurrentField(Calendar)='SoldYear',if(SoldYear=$(vMaxYear),(sum(ESTCUST)-above(total sum({<SoldMonth={'<=$(=max({<SoldYear={"$(=max(SoldYear))"}>}SoldMonth))'}>}ESTCUST)))
/
above(total sum({<SoldMonth={'<=$(=max({<SoldYear={"$(=max(SoldYear))"}>}SoldMonth))'}>}ESTCUST)),(sum(ESTCUST)-above(total sum(ESTCUST)))/above(total sum(ESTCUST))),
if(GetCurrentField(Calendar)='SoldMonth',(sum(ESTCUST)-sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))/sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST),
if(GetCurrentField(Calendar)='SoldDay',(sum(ESTCUST)-sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))/sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))))
In the above expression instead of ESTCUST i need to replace Sum(INVCOUNT)/sum(ESTCUST).
Thanks..
