Variable does not work

[#1]

Hello again,

i have two input fields, two variables: LastYear, CurrentYear

The input should connect to the command: Year

My expression looks like this:

sum({$<Year={"=$(LastYear)"}>}LINEAMOUNT)

What should this command do?

Summarize the Lineamount for the Year i wrote into the input field

But it doesnt give me what i want. It ignores it completely and gives me only Lineamount. Pls show me where i am wrong.

Thank you,

Kristian

[#2 · Accepted solution]

sum({$<Year={'$(LastYear)'}>}LINEAMOUNT)

[Miguel_Angel_Baeyens]

Hi Kristian,

It depends on how you have set your variable. If you only input the numbers, for example 2011, then the following expression should work (note the lack of quoting and parentheses):

Sum({< Year = {$(LastYear)} >} LINEAMOUNT)

Hope that helps.

Miguel

[#4]

Thank you very much. One more question if i may:

Attached is the table(picture) i am working on. In the filed "neto firme" i want to see the percentage share for the "Grupa" row of the TOTAL SUM(Grupa).

How can i address the total sum of grupa, what is the right formula for? I dont know the formula at all:

[LINEAMOUNT(selected year)]/ ...

Kristian

[Miguel_Angel_Baeyens]

Hi Kristian,

Not sure either but something like

Sum(Grupa) / Sum(TOTAL Grupa)

Hope that helps.

Miguel

[#6]

Unfortunately not. When i try this formula:

[Promet Tek. godina]/sum(Total [Promet Tek. godina])

It doesnt show me anything...

Thank you for your time.

Kristian

[Miguel_Angel_Baeyens]

Kristian,

You will need to use the same expression under "Promet Tek. godina" (instead of the label) divided into the same expression, but using TOTAL as above.

Hope that helps.

Miguel

[#8]

Thank you.

Kristian

[#9]

These Variables are realy a pain in the sitting muscle...

Ive got a new one that doesnt work properly. I would appreciate any help

Formats:

Datum_fakture: dd.mm.yyyy

vDatum: dd.mm.yyyy

Count(DISTINCT {$<Datum_fakture = {"<=$(vDatum) >$(=AddMonths(vDatum,-12))"}>} CUSTACCOUNT)

This formula should:

Give me the count of Customers in the last 12 months fom the Date out of vDatum inputbox

Count(DISTINCT {$<Datum_fakture = {">=$(=AddMonths(vDatum,-12)) <$(=AddMonths(vDatum,-24))"}>} CUSTACCOUNT)

This formula should:

Give me the count of Customers in the previous12 months

No function works properly, can somebody show me where i am wrong?

Thank you

Kristian