add totals from 2 fields (duh?)
Boy do I feel stupid. I have two formula numeric fields, we'll call them "those months" and "this month". These two fields record the numeric value in a record if the formula criteria are met. In a s...
Forum Discussion
Sure,
Field Name: "Month - Prior Months Total Target" Formula: If([Month - Prior]=true,[Target Total])
Filed Name: "Month - Current MTD Total Target" Formula: If([Month - Current]=true,[Target Total]*[Month - percent passed])
Filed Name: "YTD Total SIP Target" Formula: [Month - Prior Months Total Target]+[Month - Current MTD Total Target]
The first two seem to be working fine, the last one is causing the problem. In the spirit of thoroughness, the formula for the field referenced in the second formula is:
Filed Name: "Month - percent passed" Formula: If([Month - Current]=true,[Month - Day num]/[Month - days in each])
Field Name: "Month - Prior Months Total Target" Formula: If([Month - Prior]=true,[Target Total])
Filed Name: "Month - Current MTD Total Target" Formula: If([Month - Current]=true,[Target Total]*[Month - percent passed])
Filed Name: "YTD Total SIP Target" Formula: [Month - Prior Months Total Target]+[Month - Current MTD Total Target]
The first two seem to be working fine, the last one is causing the problem. In the spirit of thoroughness, the formula for the field referenced in the second formula is:
Filed Name: "Month - percent passed" Formula: If([Month - Current]=true,[Month - Day num]/[Month - days in each])