In a View, criteria does not seem to allow the comparision of two records in the same row
In the View setup, under the "Field Properties" window there is an option to create criteria using "and" or "or" conditions.
My requirement is to compare two field values in the same record. For example:
Field 1 : DueAmount
Field 2: PaidAmount
My criteria is DueAmount > PaidAmount
Currently it seems that I can only do :
Due_amount > " " Where " " could be a value (e.g. 600)
This is badly needed to add more data flexibility to views
4
votes
Dominique Conterno
shared this idea
Thank you again for your idea. The feature is now available in Caspio Bridge 12.0