Need Help to calculate SoW

[pavanthota]

Hi All,

I need one help to write the expression for SOW.I am providing you the sample data in excel.

I have to calculate Sow of current year like Average of prior year and priprior year shipment divided by current year tam

I have given calculation in excel for 2016 Sow. Please check and provide me the suitable answer asap.

Thanks,

Pavan

[alexdataiq]

Could you provide a Sample Application?

Are you trying to do this on the script or in the UI? If it's in a pivot, you could try with Set Analysis:

RangeAvg(Sum({<Year={2015}>} Netshipmet), Sum({<Year={2014}>} Netshipmet)) / Sum({<Year={2016}>} Netshipmet)

Or instead of fixed Years, you could use some variable to calculate the Prior Years.

Regards.

[pavanthota]

Hi Alejando,

Thanks for your quick reply,

I need to use this expression on UI on pivot.

Same expression can i use in pivot also right.

I am attaching sample example (NetShipment= Sum(Direct and InDirect)

Could you please tell me how to write this expression in script level.

I have created the variables for prior year please check and let me know

Thanks for your suggestion to create the variables.

Thanks,

Pavan

[pavanthota]

Hi Alejandro,

Could you please reply  to my question