Problems with Expressions

[Anonymous]

Hi,

I have a problem with variables.

I load variables from a spreadsheet, and it contains the necessary calculations for the formulas in the application.

I realized that if a reference that will query the two records, it multiplies the original value by the amount of logging.

example:

     Ref             Value        Discont1      Discount2

     3815738      500.00      250.00         0.00

     3815738      500.00      0.00             250.00

In the charts this reference is:

     Ref             Value          Discont1      Discount2

     3815738      1000.00      250.00         250.00

The value of the variable is:

     sum ({<[Course type] = {"> 1 <3"}>} VALORORIG_MENSALID)

It is called in the following chart:

     $(vMensal_Grad)

If I add the DISTINCT, the value of the variable, it will only sum the distinct values ​​with this value be unreal.

example:

         Without DISTINCT: 20 million

         With DISTINCT: 2 million

How do I make it add up the values ​​of distinct references, and not of distinct values​​?

I hope I have managed to demonstrate the problem.

[vadimtsushko]

Hi Bruno.

Should you prepare an example of application with your data and current expresssions and add comment or excel table with desirable results, I believe community would have better chance to help you

Best regards, Vadim