Create Customer Billing Scenarios.

[eru-alelo]

Hello, I am a beginner in Qliv and I need to create Customer Billing scenarios to analyze their monthly performance.

To arrive at the result of items 1, 2 and 3, I have to make an account of the current month about the average billing that will give me a%

= IF (Current Month / Average Fat for> 1.3; "Increased Fat"; IF (Current Month / Fat Mean for> 0.7; "Fat Stable"; "Reduced Fat")))

It's 4 should consider the current month without billing,

It is 5 should consider current month, plus the last 2 months previous, without billing

It is 6 should consider current month, plus the last 4 months previous, without billing

It's 7 should consider current month, plus 1 month before, without billing

Desired Scenes:

1- Stable Billing,

2- Increased Billing,

3- Reduced Billing,

4- No Billing, (current month without billing)

5- Churn 90, (3 months without Billing)

6- Churn> 90, (Over 3 months without Billing)

7- Churn 60, (2 months unbilled)