Using Where Condition

Question & Answer
, ,
1

HI All,
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.

Regards
Arun k

1 Like
2

not certain of your end in mind, but have you tried
sum(ifelse(Month=‘Current Month’,Cost,0))

3

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 .

Regards
Arun K

4

Can you show examples of data and how you would like this column to be calculated?