Day 17 Bex Query Formula Variable, Date as Key Figure, If Condition, Exception Aggregation
Explained on below topics
1. Creating formula Variable to get distinct count (using Bill Number as an example)
2. Using Date as a key figure ( Explained by calculating the difference between dates in key figure section)
3, Writing If Logic in Calculated Key Figure ( Explained with a Scenario)
4. Usage of Exceptional aggregation while using Formula Variables in the report.
