Hello,
I currently have a GI set up to display an amount with a decimal that is two digits in so we can display it as 1111.00. Does anyone have any tricks for getting the value to add commas in after the hundredths place? Below is my current config.
=iif([ComplianceDocument.LienWaiverAmount]=null,'-',left(cstr([ComplianceDocument.LienWaiverAmount]),instr(cstr([ComplianceDocument.LienWaiverAmount]),'.')+2))
Thank you,
Justin Long
Best answer by lauraj46
Hi
Depending on how many decimal places are configured in your system settings, you could consider specifying a schema field instead of the formula. The GI will use the schema field for formatting the output of the column. If there is an appropriate field (currency or qty) that’s already in your GI then you can use that, or you can add any DAC to the GI and use a field from it as the schema. As long as the DAC isn’t included in the Relations, it won’t affect the query processing.
The schema field also sets the headings for the column, but you can correct this by using the Caption property.
Hope this helps!
Laura
+9Hi
Depending on how many decimal places are configured in your system settings, you could consider specifying a schema field instead of the formula. The GI will use the schema field for formatting the output of the column. If there is an appropriate field (currency or qty) that’s already in your GI then you can use that, or you can add any DAC to the GI and use a field from it as the schema. As long as the DAC isn’t included in the Relations, it won’t affect the query processing.
The schema field also sets the headings for the column, but you can correct this by using the Caption property.
Hope this helps!
Laura
Hey Laura! I was so caught up in the formula that I completely forgot about the schema field. I added a unrelated DAC like you suggested and that did the trick right away.
Thank you for your help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
