Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have a problem to get the matching objects for the budget (data is not related by the date range):
Could somebody help me please to get the correct values in the column "Buget" for
- 01/2010 --> forecast-value "20" in column "Budget"
- 02/2010 --> forecast-value "231" in column "Budget"
Attached you can find an example QVW-File and the 3 example-XLS-Sheets.
Thanks a lot.
Regards,
jup
...
Whoops... I didn't read the topic until the end.
Well, in the last Qvw file you have this expression:
=sum(if(num([HEL_DATA_Datum > MONTH])= SAL_PLANDATEN_Budget,SAL_PLANDATEN_Budget))
This is wrong.
num([HEL_DATA_Datum > MONTH]) is a month (1-12).
SAL_PLANDATEN_Budget is a budget (dollars).
Using the if can't extract you anything.
You have to compare apples to apples .
Probably that line should read:
=sum(if([HEL_DATA_Datum > MONTH]=Num#(SAL_PLANDATEN_Monat), SAL_PLANDATEN_Budget))
If I understand the field names correctly.
Now, for the "wrong" values. It depends upon the many join you pass from table PLANDATEN (where the Budget is) to table HELIOS (where Month is). AFAICT, it makes no sense.
You should first understand what you're doing.
Probably, as a quick solution, you can do:
=Only(if([HEL_DATA_Datum > MONTH]=Num#(SAL_PLANDATEN_Monat), SAL_PLANDATEN_Budget))
hello juppinger,
i have the same problem an i'm interested of a solution too. Maybe you need here the "aggr" function, but i'm
not sure.
Does anyone have an idea ? Thanx..
Greetings,
Hi
Here is your Ans.
Have a look at the attched Document.
Regards,
Kaushik Solanki
Hi Kaushik,
very crazy - in my attached QVW-File I will not work!!!
Could you help me please again?
Thanks a lot,
jup
Hi,
Convert the month number in text as the field you are joining is a text.
try below.
text(num([HEL_DATA_Datum > MONTH]))
Regards,
Kaushik Solanki
Hey... other strange thing happens... (wrong values)
Please find the new qvw attached.
please help again
hi togehter,
really very strange ! I downloaded your file too and do not understand that. Exactly the same thing i want to do in my application and it also doesnt work.
If someone has a solution, i would be interested too. Thank you !
Kind regards
Please help us!
Thanks a lot,
jup
Hi,
Please also help. How do we get our best realized simplest problem?
Are there any recommendations? Thank you.
Best Regards
Found the matching topic...!
I also got this problem!!! 😞
could anyone help, please?