Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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
Closeset number it a variable name that eqauls to this formula FirstSortedValue(DISTINCT Vs, fAbs(Vs-NewVs))
I have updated the formula of Ps New Vs but its not working again as you can see below
can you share the test app?