Formula probleme

[LhZagora]

Can any tell me why this formula doesnt work 

this formula represent PS new Vs , what im trying to do is that i have a table with : those variable :

the point its to to calculate new Ps when a i have a new vs as input. 

Can someone help please.

I have calculted the closest number via this formula : FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))

[bhaskar_sm]

Hi,

Can you please tell us  Closest Number is a value , field name or variable name?

if its a value you then need to put this in single quotes i.e 'Closest Number '. or

if its a field name then you need to put this in square brackets or in double-quotes i.e "Closest Number" or [Closest Number]

if its a variable name then you need to use $ sign i.e $(Closest Number)

Thanks,

BK

[LhZagora]

Closeset number it a variable name that eqauls to this formula  FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))

[LhZagora]

Closeset number it a variable name that eqauls to this formula  FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))

[LhZagora]

I have updated the formula of Ps New Vs but its not working again as you can see below

[bhaskar_sm]

can you share the test app?