Forum Discussion
anupambit1797
Mar 09, 2024Iron Contributor
Index Formula
Dear Experts, I need the logic/formula for the below:- Consider , I have a String "Anupam is a Student" , I want to split it into the row-3 as shown each char/space in a cell as s...
- Jul 19, 2024
Your method works, but you can simplify it by using:
```sql
CCur(Round([Gross Amount] * [VAT Percentage] / (100 + [VAT Percentage]), 2))
```
This VAT Calculator method keeps it as currency and exports correctly to Excel.
Detlef_Lewin
Mar 09, 2024Silver Contributor