Error in formula...

[danialier]

Hello,

For some reason the formula below does not work... What I want is to have the result of doing; units from CompanyA in the last period (so the current period) minus units from CompanyZ in the previous period.

=num(sum({<Vendor={'CompanyA'},Period={$(=Max(Period))}>}units)-sum({<Vendor={'CompanyA'},Period={$(=Max(Period)-1)}>}units))

thks,dani

[#2]

try this :

=num(sum({$<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units)-sum({$<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

[MK_QSL]

Use as per below to get the Grown in Unit compare to last month.

=num(sum({<Vendor={'CompanyA'},Period={"$(=Max(Period))"}>}units)-

sum({<Vendor={'CompanyA'},Period={"$(=Max(Period)-1)"}>}units))

Also make sure that your format of your Period and $(=Max(Period)-1) should be same.

[Peter_Cammaert]

I guess the CompanyZ you're referring to in your question is a typing mistake?

Peter

[Anonymous]

the error could be in the Period={$(=Max(Period))}>} because you can try like this by seeing below syntax

syntax 1: DayOfYear = {"<=$(=max({<FiscalYear={$(=vCY)}>} DayOfYear))"}

If it does not work please post the qvw file it would be easy to solve.

[santharubban]

try this

=num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units)-

sum({<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

[aveeeeeee7en]

Hi Dani

Try this:

=num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units))

-

num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

Regards

Aviral