Calculated Values does not return Currency of float Number

[VincenzoCocciolo]

I'm pulling my hairs since yesterday.

In a Submission Form I'm tring to poplulate fields or virtual fields with currency or Numbers stored in other table via SQL SELECT. It always return zero!

I tried "most" combinations of SELECT CAST or using the Converter Formula but nothing!!!

If I change the SQL SELECT inserting fixed values in the WHERE fields works .

 

What did I miss?

This Works!

This Return Zero

 

 

 

[CoopperBackpack]

Hello @VincenzoCocciolo,

You may try these options:

1) If the VATID field is populated by the user manually in the Submission form, please test adding the 'target' keyword

SELECT Percentuage FROM VAT WHERE VATID = target.[@field:VATID]

2) If the VATID is received as an External parameter, then the syntax is [@VATID] or the other parameter name that is used as a parameter to receive

SELECT Percentuage FROM VAT WHERE VATID = [@VATID]

Hope this helps!

[autonumber]

Hi! You might find this link useful for Function Reference for SQL Statements.

https://howto.caspio.com/function-reference/