Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please can someone help?
I need to match my budget back to my Data with the numbers next to each channel in my expression. | |||||||||
Data | Data | Excel Upload | |||||||
Example: | PriorYear | CurrentYear | Budget | ||||||
RECON | 100 | 200 | 250 | ||||||
FirstSubScriberClassification | SubClassGroup (Upload from excel file) | ||||||||
DIRECT | RECON | ||||||||
FINDU | DIRECT | ||||||||
IIP | FINDU | ||||||||
LSS | GUARDING | ||||||||
RECON | RESIDENTIAL | ||||||||
RESIDENTIAL | SMALL COMMERCIAL | ||||||||
SMALL COMMERCIAL | IIP | ||||||||
Formula tried but not working | |||||||||
Sum(If(SwitchDesc = 'Clients' and Description = 'Sales' and SubClassGroup = FirstSubScriberClassification, Budget)) | |||||||||
Is it because of missing ''?
Sum(If(SwitchDesc = 'Clients' and Description = 'Sales' and SubClassGroup = 'FirstSubScriberClassification', Budget))
FirstSubScriberClassification | Total | PY | CY | Budget |
RESIDENTIAL | 100 | 150 | 200 | 0 |
Does not seem to work
Budget return 0