Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi QV's ,
Please find App below ,
my problem is why i am getting Synthetic key can you please resolve
hi , plz find attachment
-lohi
hi , any one got the result
-lohi
Hi Lohi,
I could see your excel file and could not look at QVW.
But looking at excel tabs I could not understand how are you getting Syn table in Data model.
Could you please attach data model in some other format?
Regards,
hi , plz check
Perhaps I missed something but, what's the point to create a field to accumulate sales when you can do it after scripting by means of expressions?
Hi Lohi,
Now its even more confusing.
I think first you are joining both tabs data from excel then doing some calculation (cumulative).
I think if you will load excel tabs separately then Syn table issue will not arise, if u can share your load script as well then may be I will be able to understand your data model clearly.
Regards,
I suppose you're trying to add the commissions to the base-table based on the interval of the cumulativesales and the key "name-year".
Please find attached a possible solution without looping over the values of name and year, but by using the extended intervalmatch function.