Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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