Thanks.

Hi, We use Client/Server application. I also have another question, I wan to use following formula in one of my text box to display CAGR value (Compound Annual Growth Rate) which is calculated as {(Optimist.Legal_Entity.Model.Historical_Current_Yr.Net_Revenue___Value/Optimist.Legal_Entity.Model.Hist...

Hi I want to calculate a value and store in a variable and re-use the variable for further calculations in my report page. I am not sure exactly how would I do that so if you know different methods please advise. I want to create a new variable which is a % increase/decrease of last 2 years and base...

Hi, I have used this formula {Totals.Avg(Optimist.Legal_Entity.Model.Historical_Current_Yr.Commercial_and_Industrial___EBIT___Value, Optimist.Legal_Entity.Model.Historical_Prior_Yr.Commercial_and_Industrial___EBIT___Value, Optimist.Legal_Entity.Model.Historical_Prior_Prior_Yr.Commercial_and_Industri...

Hi I want to calculate Average of 3 values, these values are from 3 financial year statements in most cases but if the user has choose only 2 years it should average of two years. I am building interactive report, we have few scenarios; e.g. May not have all 3 years data point, 0 value or negative v...

Hi Aleksey, I am looking to get Average for 3 Financial statement years, my formula is not working, can you please help me to identify issue. {AvgIf(Optimist.Legal_Entity.Model.Current_Yr.Commercial_and_Industrial___EBIT___Value, Optimist.Legal_Entity.Model.Prior_Yr.Commercial_and_Industrial___EBIT_...