Due to Institution =
IF(AND([@[Total Spent]]>[@[Total Paid]],[@[Total Spent]]<=[@[Total Awarded Amount]]),
(IF([@[Total Spent]]>[@[Total Awarded Amount]],[@[Total Awarded Amount]],[@[Total Spent]])-[@[Total Paid]]),
IF([@[Total Spent]]>[@[Total Awarded Amount]],[@[Total Awarded Amount]]-[@[Total Paid]],0))
Refund Request =
IF([@[Total Paid]]>([@[Total Spent]]+[@[Total Refund Received]]),[@[Total Paid]]-[@[Total Spent]]-[@[Total Refund Received]],0)
Write-down Request =
[@[Total Awarded Amount]]-IF([@[Total Paid]]>[@[Total Spent]],
(IF([@[Total Paid]]>[@[Total Awarded Amount]],[@[Total Awarded Amount]],[@[Total Paid]])),
(IF([@[Total Spent]]>[@[Total Awarded Amount]],[@[Total Awarded Amount]],[@[Total Spent]])))