Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I hv below expression work fine :-
Sum(sales)/Sum(TOTAL(sales))
I try below expression using label name :-
Sum(CY)/Sum(TOTAL(CY))
it does not able to work.
Can some one advise me ?
Paul
Is this what you want? PFA
I have not opened your QVW, Where are you generating CY, if it a variable then you need to expand it using $ eg. below ...
Sum($(CY)/Sum(TOTAL($(CY))
You are using a wrong syntax...
This is what you are using...this will give you undesired outputs..
Sum(Money(Sum(Expression)))/Sum(TOTAL Money(Sum(Expression)))
I have attached a solution..I am using the concept of "Relative" in expression.
See if that helps.
Phani
Hi Scot
Your solution not able to work , because it is not system variable.
I use expression label name.
money(
sum({$<year = {$(=max(year)-0)}
,[Reporting Code] = {
As my CY expression is below :-
">=00100<=
00374"
}
, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/$(ColumnDim98)*-1)/1000
, $(vMoneyFormatK_GL))
Paul
First try to clean your data model, later see what happens
Hi,
Try this expression for Contri
=sum({$<year = {$(=max(year)-0)}
,[Reporting Code] = {
">=00100<=
00374"
}
, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/$(ColumnDim98)*-1)/
sum( {$<year = {$(=max(year)-0)}
,[Reporting Code] = {
">=00100<=
00374"
}
, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL Amount/$(ColumnDim98)*-1)
Regards,
Jagan.
Is this what you want? PFA
Hi,
Use the label name in between the square brackets like Sum([CY])/Sum(TOTAL([CY]))
Hope it helps you
Please find the attachment......... hope it is solved.......... adn validate with text object.......
Hi All
Thank you very one for your help . I must said those who expression = CY is the best . as it is less work and achieve the same result.
Some one suggest to me clean my data model , yes i admit my data model is messy. i already try few time but fail. because not easy to handle link table. also partly i am not a programmer. but it is just like live in poor country , a bit of hard to change the environment, but i will try.
Paul