Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all , i have a text box tht calculate something like this : sum ( {$<Subject={1},[status]={3}>} amount )
and i have a variable like this : vY = if ( type38=1 or type39=1 , amount , 0 )
when i replace amount with $(vY) i expect to see that the result will Decreas Significantly BUT instead i see Increas ,
what could be the problem ??
i exported the data to another model - and its work OK !?
thanks .
It is hard to tell with out looking at your datamodel. Can you post a sample app.
hi phaneendra.kunche ,
it is a complicate model and sensitive data , so its a bit difficult to show it .
Anyway, I gave up ... - I solved the problem in the script .
- thanks!
may be repetition of data? cross joining ? etc
Hi Yaniv
If the data works on another model, you are probably changing the 'vY' variable somewhere else in your script
Maybe put a trace on that variable to see if it has the expected value after the load.
In the expression of vY, remove the preceding '='
[Assuming your variable expands to
sum ( {$<Subject={1},[status]={3}>} if ( type38=1 or type39=1 , amount , 0 ) )
it's often a good idea to simplify the expression first, e.g. test with a hard coded expression to eliminate an issue with variable dollar sign expansion
]
What is the relation of fields type38,type39 and amount? Do these fields reside in the same table or in different tables?
If they reside in different tables, QV may need to do a temporary join of tables to make the record-level comparison possible, this may duplicate your amounts in comparison to the first version.