If statement SUM calculation

[#1]

Hi I am trying to achieve the following.

i have three companies

000

001

003

000 and 003 share the same database, therefore i recieve double values when running the following sum for company 003. 001 is correct so no need to worry about that.

what i want to do is half the amount for company 003 based on the following calculation.

psuedo if(company = 003......), otherwise  ->

Sum(OrderRad.ResterandeBelopp * #Dat_O * OH.Kurs_FSG_act)

Best,Brad

[#2]

try this

if(company = 003,Values*0.5,Values)

[CELAMBARASAN · Accepted solution]

Sum(OrderRad.ResterandeBelopp * #Dat_O * OH.Kurs_FSG_act)

I don't get what this expression says

May be for your requirement expression will be

(Sum({<Company={'000', '003'}>} Sales) * 0.5) + Sum({<Company-={'000', '003'}>} Sales)