Need help in creating calculated field based on condition.
Example 1 : Sum(Cost) where Month=‘Previous Month’.
Example 2 : Sum(Cost) where Month = ‘Current Month’
I have created calculated field for Current month and Previous month, which brings value.
not certain of your end in mind, but have you tried
Thanks for the reply. But it does not work.
my requirement is… First column has August month cost and I need to add previous month cost in Next column and Next month(September ) Forecast in Next column .
And I need to Subtract Current month from Previous month in Next to Next column .
Can you show examples of data and how you would like this column to be calculated?