I’m trying to add two measures to my report that will give me the following:
1. An actual to budget variance column. The only trick is that it needs to evaluate the account type and if it is a Revenue account, it needs to do Actual minus Budget, but if it is a Cost or Days accounts it needs to...
I've three columns excelsheet and want to create Per day report.
I want to count per day records and status.
This will be self-explanatory when you check this screenshot. Please suggest me some functions/formulas.