Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum({$<Year={'$(LastYear)'}>}LINEAMOUNT)
sum({$<Year={'$(LastYear)'}>}LINEAMOUNT)
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
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
Hi Kristian,
Not sure either but something like
Sum(Grupa) / Sum(TOTAL Grupa)
Hope that helps.
Miguel
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
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
Thank you.
Kristian
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