Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try your expression with distinct function
sum(distinct if(alt([Billing Day],0)=0,([Order quantity_WMENG]*Net_Price/ExhRate,0)))
if problem doesn't solve then try this
sum(distinct if([Billing Day]=0,([Order quantity_WMENG]*Net_Price/ExhRate,0)))
hope it helps
try this
=if([Billing Day]=0,sum(Distinct ([Order quantity_WMENG]*Net_Price) / ExhRate),0)
That wouldn't work. The reason why I need to use "alt"-statement here is that I want to include onlu those rows into calculation where Billing day doesn't exist, so with the normal if formula I get nothing.
Try your expression with distinct function
sum(distinct if(alt([Billing Day],0)=0,([Order quantity_WMENG]*Net_Price/ExhRate,0)))
if problem doesn't solve then try this
sum(distinct if([Billing Day]=0,([Order quantity_WMENG]*Net_Price/ExhRate,0)))
hope it helps
Great! the first one did work! Many thanks!
-Janne