Boolean If/then/else help needed
Ninox Profile

I created a simple Boolean if X & Y then A * B else end (sample code below). The idea is for us at our school to only enter date ranges and then have the contribution fees to run the school calculated automatically. The two main variables to check are to check if they are in Kindergarten or Primary school and the length of their expected attendance. I'm not sure what I'm missing but at the moment the formula is not returning anything.

if Group = "Kindergarten" and 'Days Attended' < 5 then

'Days Attended' * 'Contribution Fees'.'Kindergarten Daily (5 > days)'

else

End

Reply