Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need help creating a load script for an app with calculated columns. Attached is sample data
The calculated columns are [Days for Calculation], [Daily Rate], and [Monthly Fee].
[Daily Rate] is [Fee Monthly Rate] divided by [Days for calculation].
[Monthly Fee] is [Days for calculation multiplied by [Daily Rate].
Below are the four possible scenarios to get [Days for Calculation]:
Do you want to split the costs into the months they belong to? In this case you can use intervalmatch() to either match dates or months.
Thanks for the response but this gives me little to go by. I need a load script that would
1.calculate the [Days for Calculation] column according to the four scenarios mentioned above.
2. calculate [Daily Rate] which is [Fee Monthly Rate] divided by [Days for Calculation]
3. Calculate [Monthly Fee] which is [Daily Rate] multiplied by [Days For Calculation].