Set Analysis

[carolin01]

Hi,

Could anybody help me to correct my variable:

vRevenueTotalMax = sum({$<FYear = {$(=Max(FYear))}, OrderPhase_Desc = {Revenue}>} NettAmount$(vCurrency));

I would like to see the Revenue for the Maximum Year that I choose from a List box. But it´s not calculating anything.

It´s for sure something about brackets etc or similar...

Many thanks for your comments.

Best regards

Carolin

[#2]

Is NettAmount$(vCurrency) supposed to read as NetAmount$(vCurrency)?

[#3]

sum({$<FYear = {$(=Max(FYear))}, OrderPhase_Desc = {'Revenue'}>} NettAmount$(vCurrency));

Quotations around Revenue?

[carolin01 · Accepted solution]

Quotation didn´t seem to help. This is a formula that I use which is working:

  = sum({$<OrderPhase_Desc = {Revenue}>} NettAmount$(vCurrency));

Now it should include the Max-Year Term...

[carolin01]

NetAmount$(vCurrency) should be read as e.g. NetAmountEUR or NetAmountUSD

[#6]

Try:

vRevenueTotalMax = sum({$<FYear = {Max(FYear)}, OrderPhase_Desc = {Revenue}>} NettAmount$(vCurrency))

[carolin01]

Unfortunately not: this is how it´s looking like:

sum({$<FYear = {Max(FYear)}, OrderPhase_Desc = {Revenue}>} NettAmountUSD)

[#8]

sum({<FYear={$(=Max(FYear))},OrderPhase_Desc={'Revenue'}>}NettAmount$(vCurrency))

Just checking its not the current selections

[manideep78]

Try this,

vRevenueTotalMax = sum({$<FYear = {"$(=Max(FYear))"}, OrderPhase_Desc = {'Revenue'}>} NettAmount&$(vCurrency));

[#10]

sum({$<FYear = {Max({$}FYear)}, OrderPhase_Desc = {Revenue}>} NettAmountUSD) ?

I feel like FYear = {Max(FYear)} does not consider the current selection, so maybe the above will work.