URGENT help needed please/show sales figures per month in list report

[cbyrne123]

Hello i am creating a list view report and need to show sales each month, so customer/Period 1, Period 2 etc, periods being Jan and Feb for example.

I have tried the below DataItem expression however this doesn't to work Properly.


IF  ([Period] ='7') THEN ([Line Value]) ELSE([Line Value])

Thanks

Chris

[cognostechie]

You have the same value in THEN as well as ELSE.

Try - IF  ([Period] ='7') THEN ([Line Value]) ELSE(0)