Construct Expression

[nareshthavidishetty]

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..

[nareshthavidishetty]

Hi,

Please let me know how to get this.

Thanks..