if vs set

[#1]

Hi, I have read in various threads that set should be faster and give better performance than if.

I have a case where I just need to say if FieldA = 'x value' then for instance multiply field B, field C and Field D.

It seems silly to make a set for all fields, so I would expect an if solution to be the choice?  

[rajeshvaswani77]

Hi Mikael,

It would be like this.

thanks,

Rajesh Vaswani

[maksim_senin]

Hi,

It's really difficult to understand the root cause of the issue, just one suggestion:

1. try break down your expression to elementary elements and show the in a table

2. add set analysis to each element and look whether they (a) calculated without errors and (b) satisfy your expectations

Best regards,

Maxim

[#4]

thx, yes the set version works but would it make sense in an if analysis?

[#5]

thx, and sorry I see it became a bit messi. I should have started with the set analysis and then ask how to make it with If analysis, as I just did in response to Rajesh.