IIF statement + some math

[jirakst]

Hello,



what is wrong with this formula: Profit: IIf([Side]="Short";[Exit]-[Entry];[Exit]-[Entry]) ? It returns quite weird number and I can't figure out why.
Thanks!

[JoeM]

First, your formula doesn't seem to make much sense. You seem to be telling it to return exactly the same thing if you condition is True or False:
[Exit]-[Entry]
In that case, why even bother checking if you are going to return the same formula either way?

Please provide an example of of what the values or [Exit] and [Entry] are, and what is being returned.

[jirakst]

Sorry, it should be as follows: IIf([Side]="Short";[Exit]-[Entry]*(-1);[Exit]-[Entry]). I forget to copy the (-1).

[JoeM]

[Exit]-[Entry]*(-1)
can simply be replaced with:
[Entry]-[Exit]

If still having issues, please lay out an actual example that is not working for you.
That is, let us know the values for [Entry] and [Exit] and let us know what result you are seeing.

[jirakst]

It already works. But I'd like to use comma separated number, e.g. Entry=42,225, Exit=45. Is there any way, how to do that?

[NTC]

comma separate format should be able to be achieved by definition the type number in the format of the field

[jirakst]

I've got it. Thank you very much.