Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I'm facing a problem. I have data like accounts and debits. Also i have groups like income, margin e.t.c and accounts.
i summarized in a pivot chart the debit. Also i have created variables for each group and in the chart i calculate the new value of debit according the value in the variable you give. So far everything is working correct.
Some accounts are the same for Income and Margin.
Can anyone knows when i change a variable to change also the debits in income group and margin group because of the same accounts?
I attached a sample QVW.
Thank you in advance.
Probably you have used '=' while declaring variables... Don't use = sign
Cost_Var
SUM({<GROUP = {'Cost'}>}DEBIT)
Margin_Var
SUM({<GROUP = {'Margin'}>}DEBIT)
etc
I want to give manually the percent in an input box and effects by calculating also the income and margin because of the some same accounts they have. Can i do this and with which way ?
Not understood your requirement properly. Could you please elaborate in brief?
If you see in the attached file i have sent i have some variables. Also some accounts are same for income and margin.
How can i calculate with giving manually a number in the variable the same accounts in income and margin in the level of group ?