hi guys

 started fumbling around again (hoping to get some quiet days during the holidays to really start building serious reports) - i'm not sure what are my capabilities of working directly in Prism with fomulas. case in point: simple profit and lost table - sales, cost of sales, R&D, S&M and General expenses - all these are items on the excel. what i'd like to do is show Gross and Net profit - which doesnt appear on the excel of course - directly in Prism. the Custom Measure only lets me do computations of available measures, such as "sum" - but how do i define ("sum of sales" - sum of Cost of Sales")?

Hi Guy,

Right click the Measures node in the data browser and create a new custom measure.  In the formula editor (above the canvas), drop the two measures (sum of sales and sum of cost) onto the formula editor with a minus sign between them.  Click enter and type in the name "Profit".  This will create a measure in the data browser called profit that is calculated by sales minus cost.

Is that what you were looking for?

Elad

Additional information can be found at:

http://www.sisense.com/Support/working_with_formulas.aspx